Find the collections which does’nt have members

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

Leave a Reply

Your email address will not be published. Required fields are marked *