SCCM Empty collections

This report will show all the empty collection in your SCCM:





select
    C.Collectionid,
    C.Name
from
    dbo.v_Collection C
Where
    C.Collectionid not in (Select Collectionid from dbo.v_FullCollectionMembership)