SQL Query to find a machine is part of which collection
- MECM Techie
- Apr 16, 2021
- 1 min read
Here is SQL query to find machine is part of collection.
select c.collectionID, c.name, fc.name from v_collection c join v_FullCollectionMembership fc on c.collectionID = fc.collectionID
where fc.name = 'Host Name' order by c.Name

Comments