List Collection a PC belongs too.

Select
FCM.CollectionID,
C.Name
from
dbo.v_Collection c
join dbo.v_FullCollectionMembership FCM on C.CollectionID = FCM.CollectionID
Where
FCM.Name = ‘HPPC’

Leave a Reply

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