Imagine a single manage is over 12 managers who in-turn all have 12 subordinate managers who all have teams of 10+ people - is there an easy native way to create a dynamic group membership query that encompasses ALL those people?
Head-Manager Jill <- Sub-Manager Jack (member of group because his "managedby" is "Head-Manager Jill") <- Engineer Sally (member of group because her "managedby" is "Sub-Manager JACK" who is managed by "Head-Manager Jill")
What I was about to do, if there is no native solution, is to write a daily script that does the recursion and places the "manager's manager'" in some virtual attribute of each subordinate worker - like SecondaryOwner.
then do the queries based on "managedby" or "secondaryowner".
But this is dependent on the scheduled script, and would have to be frequent enough to catch new accounts being pulled under any of the "subordinate managers"