create data base view of : group users with thier roles

[VISHLAVATH NIRO]

create data base view of : group users with their roles. can you help me out of this 

[Community Alums · Accepted solution]

Hi @VISHLAVATH NIROSHA ,

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 :

Then on your navigator type : u_user_group_role.list

Finally:

Add the Group, User, Role field to the list and then you can export it as a report

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Preethi26]

Hi Sandeep,

I have tried this but group against role mapping is not correct.

Re: Database view - ServiceNow Community

Please see my issue here. Kindly suggest.