Extract unique list of users who are managers

Sooriya3
Giga Guru

Hi

I have a requirement to extract a unique list of users who are managers. Anyone familiar with this kind of request and ideas to? I am able to filter on manager!empty, but then not a unique list.

5 REPLIES 5

Mark Manders
Mega Patron

I really don't know why scripts need to be involved. That means you can only run it once, and next time, you need to get that script again and run it again. You don't have a clean export or anything like that. Just create a report for it so you can always call it (and also people without access to scripts can).

OOB there is a related list 'User -> Manager (sys_user.manager)'. That means you can just create a simple list report on the sys_user table with a related list condition where related list table = User -> Manager and select 'Greater than or Equal to 1' as condition. This will show you every user that has at least one person he or she manages: 

MarkManders_0-1744368095459.png

 


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark