Report provide count of computers from the collections. Full Details: http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/f0cccbd7-7616-4d06-a3a6-31d4c583e2f0 SELECT v_Collection.Name ,v_Collection.Comment,v_Collection.CollectionID,COUNT(*) as [Members] FROM v_Collection,v_FullCollectionMembership where v_Collection.CollectionID=v_FullCollectionMembership.CollectionID group by v_Collection.Name ,v_Collection.Comment,v_Collection.CollectionID order by v_Collection.Name

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…

If you have any issues with distribution of any packages to child sites or if you are in multi-tier hierarchy,You get face issues with packages not replicating to child sites due to several reasons and they will be retrying n (specific) number of times until they get right version of PCK file. Preload is Our…
SCCM Report status of Packages used in Task Sequence

Another Interesting report which will help you to identify if there are any packages used in Task Sequence are not available on Distribution Points. If the Reference packages used in Task Sequence not available on DP,your Task sequence will fail and then u come back to fix the issues so lets be proactive . SCCM…

Recap about Deployment Re-evaluation Though name indicates what it does but still clearing questions if any. Re-evaluation on Software Updates Client Agent reevaluates(Recheck) software updates for installation status helps when Computers offline/Added newly to collection or removed patches from computers. Scenario: You have created A deployment with List of patches (100) and deployed to collection…
SCCM report Count Status of packages on All Distribution Points

In my previous report,we saw complete information about Pending packages,installed packages,Targeted but not installed,total packages targeted to DP http://eskonr.com/2012/08/sccm-report-count-of-packages-available-on-distribution-points/ In todays report,we go with count of all packages information at one glance to identify and Fix total number of Packages Distributed out of which how many are installed,Pending Packages. select dbo.v_SystemResourceList.Servername as "Server Name", (select…