select sys.Name0 [Device],
sys.Active0 [Active],
sys.Client0[Client],
sys.Full_Domain_Name0 [Domain],
sys.Creation_Date0 [Creation date]
from v_FullCollectionMembership fcm
join v_R_System sys on fcm.ResourceID=sys.ResourceID
where fcm.CollectionID = 'SMS00001' --- replace the collection ID
