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

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…