I have a customer we are running a divestiture migration with who has an extremely large Active Directory. What I need to do is figure out based on a list of users (who have an LDAP Attribute populated for scope) what groups to add to our scope. Normally I would use the Recursive Group Membership report to export the data and do a VLOOKUP in excel. Unfortunately, however that report is pumping out so much data that I think Reporter fails .. because the CSV is perhaps too big at a guess.
So what I was wondering .. is there a way to modify the SQL Query for that report to allow the report to filter the User objects is searching for recursive group membership? In my case the in-scope users have “Carlicense” set to a value of “K1”