Collection Membership Query

If you are ever in a situation where you do not have Roger Zanders Right-click tools and you want to track down what collections a device is a member of, use the query below.  

SELECT FCM.Name, 
FCM.CollectionID, 
C.Name
FROM v_FullCollectionMembership AS FCM
LEFT JOIN v_Collection AS C ON FCM.CollectionID = C.CollectionID
WHERE FCM.Name = @DeviceName
ORDER BY FCM.CollectionID
Close Menu

Sorry, but I had to.

I use cookies and similar technologies to run this website to help me understand how you use it. Privacy Policy