Configuration Manager report – All about Microsoft Endpoint Manager

SCCM Report count child sites reporting to Primary

Posted on August 14, 2012 by Eswar Koneti | 0 Comments | 96 Views

In a Big environment to know/work based on regional wide kind of doing some maintenance tasks in SCCM ,this would would help you to get you the count of Child sites reporting to primary. select ReportingSiteCode ,COUNT(*) as [Child sites] from v_Site group by ReportingSiteCode order by ReportingSiteCode

SCCM Linked report MS Office Version with Service Pack installed machines

Posted on May 30, 2012 by Eswar Koneti | 10 Comments | 6,311 Views

If you have referred to my previous report linked report http://eskonr.com/2012/05/sccm-linked-report-count-of-computers-assigned-to-specific-ad-site/ this would be easier for you to go. You need to create 2 reports 1)Count of MS Office Versions with Service Pack 2) list the computers with MS Office and Service pack installed Create new report from reports node for 2) list the computers…

Configmgr(SCCM) report for computers falls within Subnet

Posted on January 18, 2012 by Eswar Koneti | 2 Comments | 239 Views

had a requirement to see how many computer falls within the specific subnet. select a.name0,b.IP_Subnets0 from v_R_System a,dbo.v_RA_System_IPSubnets b where a.ResourceID=b.ResourceID and b.IP_Subnets0 in ('192.168.10.0') group by a.name0,b.IP_Subnets0 You can include other subnet details if you need.