Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Does the attached image show a record?

LFleming
Tera Contributor

From close reading of ServiceNow documenation and some on_demand course, my impression is the image below shows one user record.  Prior to working with ServiceNow, I would have thought the image shows one user record plus 28 sys_user_has_role records, 29 records in all.

 

Which count is correct?

1 record

29 records

 

user.png

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @LFleming 

 

The image shows 1 user record, and that user has 45 roles and is part of 1 group..

*************************************************************************************************************
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]

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

Is sys_user_has_role a table?

Does it contain records?

Do rows in sys_user_has_role correspond exactly to each role the user has?

Does that mean the user record contains sys_user_has_role records?

Ankur Bawiskar
Tera Patron
Tera Patron

@LFleming 

My thoughts from your image

1) it's 1 user record (sys_user)

2) that user is member of 1 Group (sys_user_group)

3) If you clearly see Roles Record there are total 45 (sys_user_has_role)

a) some are inherited = true means those roles got added to that user because of group membership and user got those roles because user is member of that group

b) some are inherited = false means those roles are directly given to user such as admin

AnkurBawiskar_0-1756219643132.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader