Experts, In our SMS Environment we have 1 central site, 3 primary site server and 59 secondary site server entire region. i am not able to take the report client count based on primary site server. when i checked based on secondary site server, it shows nothing in client count report. Please advice How do i get the client statistics in each of secondary sites?

The SCCM client can not be assigned to a secondary site, so you won't see anything. If you want to findout how may client are under you secondary, then you should create a report based on the site boundaries.Regards, Madan | www.madanmohan.com

Thanks Madan, Can you please provide some example report query.

Hi Siva Kumar, You can get started with this SQL queries.. The following query reports the list of sytems that are in a specifyed IP subnets. Replace '192.168.0.0','192.168.1.0', etc.. with your IP subnets. SELECT SYS.Netbios_Name0, SYS.User_Domain0, SYS.User_Name0, AIP.IP_Subnets0, SYS.Client_Version0 FROM v_R_System as SYS JOIN v_RA_System_IPSubnets as AIP on SYS.ResourceID=AIP.ResourceID WHERE AIP.IP_Subnets0 in ('192.168.0.0','192.168.1.0') Order by SYS.Netbios_Name0 Counts the number of system in a selected IP Subnets: SELECT count(distinct sys.Netbios_Name0) FROM v_R_System as SYS JOIN v_RA_System_IPSubnets as AIP on SYS.ResourceID=AIP.ResourceID WHERE AIP.IP_Subnets0 in ('192.168.0.0','192.168.1.0') group by SYS.Netbios_Name0 Regards, Madan | www.madanmohan.com