Vidéos d'aide de Screencast

CollectionMembership cm

Created: 02 Mai 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:

Commentaires CommentairesAccéder au dernier commentaire

l'image des HighTower

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?

l'image des AltirisJunkie

They exist in my 7.1 database

 collectionmembership.jpg

vCollection.jpg

Hope that helps,

Clay

l'image des Andrew Bosch

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

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