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!