Is there a way to create the list of Roles that are directly assigned to users using ServiceNow?

[ayano]

Is there a way to centrally check the list of Roles that are directly assigned to users using ServiceNow?

Now I'm opening each user to see the Direct Role.

Is it possible to display a table-like list in Direct Role?

I want to create a list of Roles that are assigned directly to an individual rather than being assigned by a group.

[Jaspal Singh]

You need to create a Database view as below

Once done you need to create a report as below. Table as created in step 1 above.

[Daniel Oderbolz]

Dear @Jaspal Singh 

But wouldn't it be easier to filter sys_user_has_role by inherited = false?

What am I missing?

Best

Daniel

[davealdridge]

Thanks Daniel, this works perfectly

[Musab Rasheed]

Hello @ayano ,

You can make use of 'sys_user_has_role' table and group by either 'role' or 'user' field. Mark my answer as correct if that helps.