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:

SELECT  
v_FullCollectionMembership.Name,
v_Collection.Name,
v_Collection.Comment,
v_FullCollectionMembership.CollectionID
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 – http://technet.microsoft.com/en-us/library/dd334649.aspx

Advertisements

Leave a Comment here

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

WordPress.com Logo

You are commenting using your WordPress.com 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