For Systems are in respected Collection Names
SELECT    
v_Collection.Name as [Collection Name],
v_FullCollectionMembership.Name as [Client Name]
FROM        
v_Collection
INNER JOIN
v_FullCollectionMembership
ON v_Collection.CollectionID = v_FullCollectionMembership.CollectionID where v_FullCollectionMembership.Name in ('system1','System2')
——————-
Thanks,
http://paddymaddy.blogspot.com/

 

Leave a Reply

Your email address will not be published. Required fields are marked *