Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

CollectionMembership cm

Created: 02 May 2013 | 3 comments


I am not a SQL guy so help is appreciated. Alot of my older queries would reference

CollectionMembership cm

vCollection vColl

Do these not exist in the 7.1 world. At one time they worked in the 7.0 world.


Operating Systems:

Comments 3 CommentsJump to latest comment

HighTower's picture

I don't have a direct answer but here's a query that we're using to find all members of a particular filter now that we can't "copy to clipboard" for filters:


vComputer.[OS Name],
vCollection.Name AS Filter

FROM CollectionMembership INNER JOIN
vComputer ON CollectionMembership.ResourceGuid = vComputer.Guid INNER JOIN
vCollection INNER JOIN
Collection ON vCollection.Guid = Collection.Guid ON CollectionMembership.CollectionGuid = Collection.Guid

where vCollection.Name LIKE '%COLLECTION_NAME_GOES_HERE%'

order by vCollection.Name, vComputer.[OS Name], vComputer.Name ASC

Does this help?

AltirisJunkie's picture

They exist in my 7.1 database



Hope that helps,


Andrew Bosch's picture

Pretty much everything uses ResourceTargets now.  Membership is held in the the ResourceMembership table.

Sr. Principal SQA Engineer