In my environment different applications are deployed. Each application has the set of users mapped with specific roles.

Now, I need to pull a report of all the users with the role and application details. From the user module, I could not find these details. I tried to pull the details from the database tables users, user_role. But application details are not linked with the user_id. 

Can you please help me in proceeding further to generate the report of users with role and application.



You may use the System entity User_Role, to tie up User and Role, Role entity has the EspaceId so you can get the application or module.



Hi Sai,

Were you able to resolve this issue?