SCCM query for all collections

Algkindom 160 Reputation points
2023-05-13T13:14:17.4166667+00:00

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
    2023-05-15T06:38:06.2133333+00:00

    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:

    1

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

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

    The screenshot for your reference:

    2

    Looking forward to your feedback.

    Best regards,
    Cherry


     

    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
    2023-05-14T13:50:34.0733333+00:00
    0 comments No comments