Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

SQL Query to See What Collections a Workstation Belongs To

Updated: 29 Jul 2008
networkchic's picture
0 0 Votes
Login to vote

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