SCCM Report - Site - General > Boundary Report - Number of clients in AD Site

This is an SCCM report to generate a summary of the number of clients in each AD site

This report was created and tested for SCCM 2012 Current Branch

Create these parameters

• OS - available values
• Server - %Server%
• Workstation - %Workstation%
• Any - %

Then create this query in Datasets

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.Operating_System_Name_and0 like @OS

Group By

    R.AD_Site_Name0

Create a table with these fields

• AD Site Name
• Num Clients

Share on Google Plus

About Tom DeMeulenaere

Highly accomplished information technology professional with extensive knowledge in System Center Configuration Manager, Windows Server, SharePoint, and Office 365.