ITIL Licenses used

MaxwellA
Giga Contributor

4 weeks ago

Hi All, 

 

I am trying to collate the total number of ITIL licenses used within my organisation in ServiceNow. I have seen a number of articles on the web, but none of them gave me a clear answer. 

 

Can anyone assist?

0 Helpfuls
  • 313 Views
3 REPLIES 3

VikMach
Mega Sage

4 weeks ago - last edited 4 weeks ago

@MaxwellA, sys_user_has_role table gives that info. Subscription Management dashboard shows how many license purchased versus how many used. Wondering what else are you looking for?
There is User Role Histories (sys_user_role_history) table which tells when a role was added and removed.
Is there anything else in specific you are looking for?
Please elaborate!

Regards,
Vikas K

Rafael Batistot
Tera Sage

4 weeks ago

Hi @MaxwellA 

 

Go to sys_user table and filter 

 

active=true AND role=itil 

0 Helpfuls

Musab Rasheed
Tera Sage
Tera Sage

4 weeks ago - last edited 4 weeks ago

Check these two threads, Accept my answer

https://www.servicenow.com/community/platform-analytics-forum/itil-license-count/td-p/1257337

https://www.servicenow.com/community/itsm-forum/itil-licence-usage-fulfiller-role-usage/m-p/2401228

Please hit like and mark my response as correct if that helps
Regards,
Musab
0 Helpfuls