Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

CollectionMembership cm

Created: 02 May 2013 | 3 comments

Hi,

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.

Thanks.

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:

SELECT

vComputer.Guid,
vComputer.Name,
vComputer.[OS Name],
vComputer.[IsManaged],
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

 collectionmembership.jpg

vCollection.jpg

Hope that helps,

Clay

Andrew Bosch's picture

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

------------------------------------
Sr. Principal SQA Engineer
Symantec