How to customise list view for all users with their corresponding roles

NDC24
Tera Contributor

Hi Everyone,

I am new to ServiceNow platform learning and building my knowledge around. I have used ServiceNow for few years as a ITIL user in ITSM application.

 

I am using my PDI, where I am looking at customising all users with their corresponding assigned roles, in [sys_user] table. First I tried using config > List Layout and add "Role" and I could see only some odd users coming up with their roles, per figure A

 

I then tried creating a new View as "Role" and selected all necessary filter selection as per attached figure B. but I am still unable to see their roles, per figure C. I know users have roles assigned via "Related List > Roles tab" 

 

I am not sure what I am doing wrong here.

 

Hope someone could help me out here 🙂

 

Many thanks everyone!!

1 ACCEPTED SOLUTION

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @NDC24 

 

The reason is , you are referring the field call Role on user form, where roles are related list, so we cant get on list view.

 

AGLearnNGrow_0-1712921663568.png

 

AGLearnNGrow_1-1712921750993.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @NDC24 

 

The reason is , you are referring the field call Role on user form, where roles are related list, so we cant get on list view.

 

AGLearnNGrow_0-1712921663568.png

 

AGLearnNGrow_1-1712921750993.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

I'm curious why "Roles" is available as a selection when displaying the list of users (i.e. on Department) then.  Is it referring to something other than the rows that a user is a member of?