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:
where QueryExpression like '%System_OU%'
* 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!