how to find which all users who have ITIL role

Servicenow lear
Tera Contributor

‎07-12-2024 05:47 AM

Hello,

 

I am doing some exercise to determine our license usage and would like to know which users are using ITIL Role.

I know the number through subscription module but now I want to know who all has it.

0 Helpfuls
  • 1,780 Views
2 REPLIES 2

Zach Koch
Giga Sage
Giga Sage

‎07-12-2024 05:48 AM - edited ‎07-12-2024 05:51 AM

You can go to the sys_user_has_role table, go to the filter navigator and type sys_user_has_role.list,  then look up the ITIL role using the filter. This will bring back all users who have that role as this table ties the roles to the users. It will look like this.

ZachKoch_0-1720788680657.png

 

 

If this information helped resolve your issue, please remember to mark response correct and thumbs up to help future community members on this information, thanks!

Dr Atul G- LNG
Tera Patron
Tera Patron

‎07-12-2024 05:49 AM

Hi @Servicenow lear 

 

https://www.servicenow.com/community/developer-forum/need-to-help-on-pulling-report-of-itil-users/m-...

 

 

You need to make the report on the sys_user table.

 

In the condition field use this filter
Sys ID is javascript:getRoledUsers('IN','itil')

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

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