Tag Archive

Tag Archives for " sccm "

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.  Collection Membership QuerySELECT FCM.Name, FCM.CollectionID, C.NameFROM v_FullCollectionMembership AS FCMLEFT JOIN v_Collection AS C on FCM.CollectionID = C.CollectionIDWHERE FCM.Name = @DeviceNameORDER BY FCM.CollectionID

Continue reading

Direct Collection Memberships

There are a number of best practices to follow in order to ensure that collection evaluation times run as quickly as possible.   There are a number of guidelines to follow but not all are obvious. In this blog post I want to go into why you should avoid using Direct Members in collections and how […]

Continue reading