http://blogs.technet.com/b/configurationmgr/archive/2009/08/24/how-to-find-the-collection-membership-information-of-a-specific-client-machine.aspxMany times during the course of troubleshooting you may come across a situation where you need to find out how many Collections a specific Client machine is a member of. Here is how you can find that information, along with the Collection Names and theen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/configurationmgr/archive/2009/08/24/how-to-find-the-collection-membership-information-of-a-specific-client-machine.aspx#3276712Tue, 25 Aug 2009 18:14:53 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3276712Christoph Voigt<p>Using WQL you can use one of these two queries:</p> <p>1) displays all collection memberships (like the SQL syntax above)</p> <p>SELECT * from SMS_CollectionMember_a where ResourceID='system-resourceID'</p> <p>2) displays only membership in collections that do have an advertisement attached</p> <p>SELECT * from SMS_ClientAdvertisementStatus where ResourceID ='system-resourceID'</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3276712" width="1" height="1">