Monday, September 30, 2013

SCCM report for Collection names and count of Sub Collections

Following SCCM custom report provides names of all the collections where they have sub collections and count of the sub collections for each collection.
select top 10000
coll.CollectionID, coll.Name, Count (csc.parentCollectionID) as [Count of subcollections]
from v_collection coll
inner join v_CollectToSubCollect csc on coll.CollectionID = csc.parentCollectionID
group by coll.CollectionID, coll.Name
More SCCM custom reports can be found here

No comments:

Post a Comment