top of page

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,, from v_collection c join v_FullCollectionMembership fc on c.collectionID = fc.collectionID

where = 'Host Name' order by c.Name

26 views0 comments

Recent Posts

See All
bottom of page