Having multiple sites and checking the status of WSUS synchronization on all servers tedious job and child sites must sync with its parent sites to ensure right compliance levels from clients. This report will give you the status of WSUS server with Right content version. When SCCM sync with Microsoft Updates,Content version will get increment…

Sometimes I find Difficult to locate specific site from the Hierarchy(mostly if you are in large environment with many nodes) until you know where they attached to. I use the report data most of the times as reference to locate where the site resides based in its reporting site (primary) and primary site reporting to…

Once you are done with installation/configuration of the sites/Distribution Point,you start distributing the content to it.sometimes you may have to check if the site which you configured has all the content that serve for clients to receive packages. For this,you can compare the newly configured server with already existing server  which has all the content…
How to Use SQL Joins while writing SCCM Reports

  create reports for the requirement and i first start analyzing the necessity and find the information about the required information where they stored in SCCM Database (SQL views). Most of the reports (SQL) that i have created in this blog created with basic syntax’s like joins. Only certain reports go beyond the joins but…
SCCM report Count packages with no advertisements

This blog post will help you to identify packages (count) for which there is no advertisement created and not used these packages in any task sequence.Once you have the packages ,you can further take action whether you really need these packages to exist in SCCM or cleanup to save disk space and avoid unused packages…

Full Details : http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/188bb324-9217-4fa6-b814-06a3d353bf52 Boundary information (AD Site) added . select distinct v_GS_SYSTEM.Name0 as 'Computer Name',A.AD_Site_Name0, substring(AccountName0,charindex('Domain=',Accountname0)+8,(charindex('Name=',Accountname0)-charindex('Domain=',Accountname0)-10)) as 'Domain Name', substring(AccountName0,len(AccountName0)-charindex('"',reverse(AccountName0),2)+2,charindex('"',reverse(AccountName0),2)-2) as 'User Name' from v_GS_SYSTEM INNER JOIN v_GS_LocalAdmins ON v_GS_SYSTEM.ResourceID = v_GS_LocalAdmins.ResourceID INNER JOIN v_R_System A ON v_GS_SYSTEM.ResourceID=A.ResourceID JOIN v_FullCollectionMembership FCM on v_gs_system.ResourceID = FCM.ResourceID where (AccountName0 not like '%Administrator%' AND AccountName0 not like…