all users groups and roles in single report

[kkswamy]

Hi,

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

Please advise.

[Community Alums]

Not possible OOB, Roles and Users relationship are available on one table and Users and Groups relationship on another.

Regards, Bharat

[Jaspal Singh]

Hi Kotaiah,

OOB there does not exists a single table or report. You can look for database view option & get it reported using sys_user_grmember & sys_user_has_role tables.

[kkswamy]

There is an OOTB database view is available but when i am trying to run report on this, it is throwing an error,

Reporting on users with roles in groups

so i am unable to run the report in this database view, i am looking for any other alrternative solution for my requirement.

[palmen · Accepted solution]

You could create a database view to get this info.

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