SQL Query to See What Collections a Workstation Belongs To
Filed under:
Notification Server
Reference
Submitted by networkchic on 29 July, 2008 - 11:59
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
(17 votes)






Recent comments
50 min 39 sec ago
6 hours 41 min ago
9 hours 57 min ago
10 hours 41 min ago
11 hours 45 min ago
12 hours 11 min ago
12 hours 57 min ago
12 hours 57 min ago
13 hours 9 min ago
13 hours 11 min ago