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…
Browsing: SQL Queries
Having multiple sites and checking the status of WSUS synchronization on all servers tedious job and child sites must sync…
In previous post,we saw how to get list of referenced task sequence packages used in Task Sequence which are incomplete.…
Another Interesting report which will help you to identify if there are any packages used in Task Sequence are not…
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…
I was looking at client health percentage other day and found many systems were reported as not healthy though I…
Sometimes I find Difficult to locate specific site from the Hierarchy(mostly if you are in large environment with many nodes)…
If you are Performing package cleanup,this query might help you to Identify how many packages with no advertisements(standard advertisement and…