Count of PCs by AD site

SELECT
    R.AD_Site_Name0,
    Count(SMS_Installed_Sites0) AS ‘Count’
From
    v_R_System R
    JOIN v_RA_System_SMSInstalledSites SIS ON R.ResourceID = SIS.ResourceID
WHERE
    R.AD_Site_Name0 = ‘Default-First-Site-Name’
Group By
    R.AD_Site_Name0

Leave a Reply

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