Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
need assistance creating a query based distribution group for direct reports
can someone provide the OPATH logic to create a QBDG [query based] that captures the following:
mgr.Jsmith-team --- (all my direct reports, and everyone who reports into them, etc.)
thanks in advance.
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Thanks Subsun, yes I have that syntax but is there a way to recursively capture all direct reports... i.e. if you have 4 direct reports, and they have 4 direct reports under them, is there a query that we can run to capture the full recursive set of people that roll up to you?
Ahh.. hierarchy..I don't think it's possible.. you can have a script to update the group membership..and you can schedule to to run daily/hourly..
OK thanks Subsun. I wasn't sure if it was possible but that answers it for me.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent