I'm trying to get some of my reports to be more accurate. Currently I join some tables and am able to pull up the members of a filter. I would like to instead pull the members of the target. Here is an example of the filter type of joins:
SELECT vComputer.Guid, vComputer.Name, vCollection.Name AS Expr1, CollectionMembership.ResourceGuid,
vCollection.Description
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 = 'All Windows Computers'
Does anyone have a snippet of SQL of how they are able to pull target membership, instead of filter membership?