SELECT CS.Name0, RA_SIS.SMS_Installed_Sites0, S.ServerNameFROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_RA_System_SMSInstalledSites RA_SIS, dbo.v_Site SWHERE CS.ResourceID = RA_SIS.ResourceID AND RA_SIS.SMS_Installed_Sites0 = S.SiteCode
Pingback from Query to fetch client machinenames with assigned SMS server names | keyongtech