List Collections a PC belongs to

select
FCM.CollectionId,
C.Name
from
dbo.v_R_System r
join dbo.v_FullCollectionMembership FCM on R.ResourceID = FCM.ResourceID
join dbo.v_Collection C on C.CollectionID = FCM.CollectionID
Where
R.Name0 = ‘ES-03’

Leave a Reply

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