Shaun Cassells at MyITForum.com

SMS 2003 and ConfigMgr 2007, PowerShell, Scripting, Finance, Fitness and Fun

News

Locations of visitors to this page

Query: Identify ConfigMgr 2007 collections based on Active Directory OU membership

The question came up recently on how to identify which collections are based on Active Directory OU membership.

There are tons of guides on how to setup a collection based on OU membership.. but now that you have.. how many have you created?


This is quite simple direct SQL query:

SELECT [CollectionID]

      ,[RuleName]

      ,[QueryID]

      ,[QueryExpression]

      ,[LimitToCollectionID]

  FROM [SMS_ABC].[dbo].[v_CollectionRuleQuery]

  where QueryExpression like '%System_OU%'


Issues: 

*  not all collection memberships need to be based on System OU.  Varitations will be needed based on requirements

* The above query is based on a view.  If you want to see the SQL you would query the table Collection_Rules_SQL


Otherwise, happy spelunking!

Comments

No Comments