SCCM – SQL query to find all Collections server belongs to

So, here is a frequent will – I want to know all Collections server belongs to. If you have time you could check all Collections you have 🙂 But there is another more efective way – ask SQL. I like to use SCCM ConfigMgr Reporting to do that. Here is a query you can use to do the work:

FROM v_FullCollectionMembership
  inner join v_Collection on v_Collection.CollectionID = v_FullCollectionMembership.CollectionID
WHERE v_FullCollectionMembership.Name LIKE ‘%Server_Name%’
ORDER BY v_FullCollectionMembership.Name

Change the Server_Name to a server name you are interested in.

In case you never worked with Reports here is a nice guide how to create one –


Leave a Comment here

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s