For Systems are in respected Collection Names

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/