top of page
Search

SQL Query to find a machine is part of which collection


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


  • https://www.facebook.com/groups/151515570102503/

© 2021 by MECM Techie

Subscribe for MECM Techie!

Thanks for submitting!

bottom of page