Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Database view to identify users who is actively utilizing ITIL license

Vikram3
Tera Guru

‎03-08-2025 12:12 AM

I need to do database join on syslog_transaction, sys_user & sys_user_has_role tables to find out the users who are actively using ITIL licenses in servicenow.

 

This is my join and I'm strugging to do it. Can anyone help here.

Vikram3_0-1741421562788.png

 

0 Helpfuls
  • 1,247 Views
6 REPLIES 6

AndersBGS
Tera Patron
Tera Patron

‎03-08-2025 03:38 AM

Hi @Vikram3 ,

 

why not just utilize the sys_user_has_lincense table and look at last login from a user perspective. By doing this, you will get the users not logging into ServiceNow which are consuming license.

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

0 Helpfuls

Vikram3
Tera Guru
In response to AndersBGS

‎03-08-2025 04:53 AM - edited ‎03-08-2025 04:57 AM

Hi @AndersBGS Unfortunately the table is empty.

0 Helpfuls