Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrade.
Please accept our apologies in advance for any inconvenience this might cause.

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