This SQL Query will retrieve the machine names from a specified collection.
SQL Query:
Select
Members.Name
'Collection Members:'
From CollectionMembers Members
Join Collections Coll on Members.SiteID = Coll.SiteID
Where Coll.CollectionName = 'All Systems'
To see a list of all the available Collections use this query and then change the 'All Systems' collection name as needed:
Select CollectionName From Collections
No Comments