Members for a collection for a particular machine

I needed to see what collections had a membership for a machine

select
FullCol.CollectionId,
COL.Name from dbo.v_R_System r
join dbo.v_FullCollectionMembership FullCol on R.ResourceID = FullCol.ResourceID
join dbo.v_Collection COL on COL.CollectionID = FullCol.CollectionID
Where
R.Name0 = 'Machine'

If you find this article useful please leave me a comment or click on an ad to show your support.