Client Management Suite

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.

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?

They exist in my 7.1 database

Hope that helps,

Clay

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