SCCM query for all collections

Algkindom 160 Reputation points

I want a report or query to get all client computers and all the device collections that contains the client? Any idea?

Microsoft Configuration Manager
0 comments No comments
{count} votes

Accepted answer
  1. CherryZhang-MSFT 6,481 Reputation points

    Hi @Algkindom

    1, The report Hardware 01A - Summary of computers in a specific collection will show you all client that in a collection you specify.

    The screenshot for your reference:


    2, This query will show you all the collections and the clients they contain.

    Select AS Collectionname, AS Clientname From V_collection,V_Clientcollectionmembers Where V_Collection.CollectionID = V_Clientcollectionmembers.CollectionID

    The screenshot for your reference:


    Looking forward to your feedback.

    Best regards,


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Garth 5,801 Reputation points
    0 comments No comments