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