SCCM SQL Query : SQL Query for Client Count per 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
Group By

    R.AD_Site_Name0 
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s