This SQL query will count all of the SMS advanced client machines in your SMS database by Active Directory (AD) site. It will also display the client version number as well as the AD site name.
SQL Query:
Select
AD_Site_Name0 'Active Directory Site',
Client_Version0 'SMS Advanced Client Version Number',
Count(*) 'Totals'
From v_R_System
Where Client0 = 1
And Client_Type0 = 1
group by AD_Site_Name0, Client_Version0
order by AD_Site_Name0, Client_Version0
No Comments