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

Leave a Reply

Your email address will not be published. Required fields are marked *