Solved: create data base view of : group users with thier ... - ServiceNow Community

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

1,544 Views

1 ACCEPTED SOLUTION

Hi @VISHLAVATH NIROSHA ,

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 :

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

View solution in original post

52 KB

2 REPLIES 2

Hi @VISHLAVATH NIROSHA ,

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 :

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

52 KB

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.