SCCM SQL Query : SQL Query for Client Count per AD Site June 3, 2016 / sanmansp 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 Group By R.AD_Site_Name0 Share this:TwitterFacebookLike this:Like Loading... Related