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,
https://paddymaddy.blogspot.com/
