Report of Users/Groups/Roles

[doormold]

Without creating a database view, is there a way to create a report that will show:

• User 
• Group
• Role

For example, the report for me would include multiple lines:

User	Group	Role
doormold	Change Management	catalog
doormold	Change Management	itil
doormold	Service Desk	agile
doormold	Service Desk	app_service_user
doormold	Service Desk	itl
doormold	SNC Admins	agile
doormold	SNC Admins	approval_admin
doormold	SNC Admins	asset
doormold	SNC Admins	itil

[Mohith Devatte · Accepted solution]

@doormold I THINK no 

i searched for few tables but i think you have to combine sys_user_grmember and sys_user_has_role tables in data base view 

PLEASE MARK MY ANSWER CORRECT IF IT HELPS YOU

[Mohith Devatte]

@doormold EVEN IF YOU TRY TO CREATE REFERENCE FIELDS ON USER FORM TO STORE ROLES AND GROUPS THEY ARE MULTIPLE IN VALUES WHERE YOU HAVE TO USE LIST FIELD BUT YOU CANT REPORT ON LIST FIELDS 

SO BETTER TO CREATE. DATABASE FOR THE ABOVE TWO TABLES

please mark my answer correct if it helps you

[Joseph1]

Thank you for your helpful reply!

could you please help me with the "Where clause" ?

thank you in advance