Tuesday, April 10, 2012

Members for a collection for a particular machine

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

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
R.Name0 = 'Machine'

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

No comments :

Post a Comment