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.
    Blogger Comment

0 comments:

Post a Comment