SQL Query to See What Collections a Workstation Belongs To
Updated: 29 Jul 2008
This query is very helpful in trying to determine what collections a machine belongs to without having to go through Resource Manager.
SELECT vComputer.Name, vComputer.[User], vComputer.[OS Name], vComputer.[OS Version], vComputer.[IP Address],
CollectionIncludeResource.CollectionGuid, vCollection.Name AS 'Collection', vCollection.Description
FROM CollectionIncludeResource INNER JOIN
vComputer ON CollectionIncludeResource.ResourceGuid = vComputer.Guid INNER JOIN
vCollection ON CollectionIncludeResource.CollectionGuid = vCollection.Guid
blog entry Filed Under:
Group Ownership:

The Endpoint Management Community Blog is the perfect place to share short, timely insights including product tips, news and other information relevant to the Endpoint Management community. Any authenticated Connect member can contribute to this blog.