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

Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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

2,076 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.