Philip Hanlon Posted May 18, 2021 Share Posted May 18, 2021 Hoping someone can help me, im trying to run a report of all staff with their job title and username, team, dept and also trying to pull in their manager but cant figure out what table it is in or how to pull it into my attached report? @Bob Dickinson is this something you could help with? user-id-with-full-name.report.txt Link to comment Share on other sites More sharing options...
Steve Giller Posted May 18, 2021 Share Posted May 18, 2021 Off the top of my head, the Manager is stored in h_sys_user_profiles, you can join on User Id Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now