SQL Query to See What Collections a Workstation Belongs To
Filed under:
Notification Server
Reference
Submitted by networkchic on 29 July, 2008 - 12: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)
- Login or register to post comments
- 1736 reads
- Printer-friendly version
















Recent comments
1 min 33 sec ago
16 min 11 sec ago
56 min 8 sec ago
2 hours 28 min ago
2 hours 31 min ago
2 hours 32 min ago
2 hours 43 min ago
3 hours 40 min ago
3 hours 56 min ago
3 hours 56 min ago