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