Your company's ad could live here and reach over 50,000 people a month!

Share This Post

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!

Share This Post

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

Leave a Reply