List PC with site code and site server name

SELECT CS.Name0, RA_SIS.SMS_Installed_Sites0, S.ServerName
FROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_RA_System_SMSInstalledSites RA_SIS, dbo.v_Site S
WHERE CS.ResourceID = RA_SIS.ResourceID AND RA_SIS.SMS_Installed_Sites0 = S.SiteCode

Published Sunday, November 23, 2008 9:49 PM by Garth
Filed under: , , ,

Comments

# Query to fetch client machinenames with assigned SMS server names | keyongtech@ Sunday, January 18, 2009 10:37 AM

Pingback from  Query to fetch client machinenames with assigned SMS server names | keyongtech

by Query to fetch client machinenames with assigned SMS server names | keyongtech