Build a report of managers from active users

[jlaps]

I need to build a report of MANAGERS, from our list of active users that have that person listed in the MANAGER field. I am having a problem conceptualizing this in a report, though I can say the words. How do I build a report to return managers, where a manager is someone in the manager field from my active user list?

[Yousaf]

Hi @jlaps 
Go to user table and try this

This will create a basic report for you you can make changes as per your requirement

Please Mark Correct and Helpful if it helps.

[jlaps]

I did something similar, without the bars, but I am dealing with 402 ish managers (grouped by manager field). Not perfect, but I have the count.

[jlaps]

And the follow up to that, is how many of those managers do NOT have ITIL...

[Yousaf]

Not sure but may be you can make use of 'sys_user_has_role' table

else you can try writing script include and call that script include in the report