SCCM query for all collections

Question

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

Answer 1

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 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:

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.

Answer 2

You can find what you need within the Sql views doc. https://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/sql-server-views-configuration-manager