MECM TechieApr 16, 20211 min readSQL Query to find a machine is part of which collectionHere 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.collectionIDwhere fc.name = 'Host Name' order by c.Name
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.collectionIDwhere fc.name = 'Host Name' order by c.Name