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