all users groups and roles in single report

kkswamy · ‎01-31-2018

Hi,

Is there any way to get the all the users and their groups and roles in a single report?

Please advise.

palmen · ‎01-31-2018

You could create a database view to get this info.

System Definition -> Database Views
Create a new view with name u_user_group_role and save.
Now you can add the view tables as follows
Go to the new view you created by typing the view name in the filter navigator
Add the Group, User, Role field to the list and then you can export it as a report

kkswamy · ‎01-31-2018

thanks you very much, it worked for me.

Preethi26 · ‎10-19-2023

Hi Team,

Same issue Iam facing I created database view as above, but role is not correctly mapped to roles.

Please check and help

cwillard · ‎08-07-2023

I know this is an old post - but can I create a database view to report on which tables a user has access to view cases on?