ITIL Licenses used

[MaxwellA]

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?

[VikMach]

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

Hi @MaxwellA 

Go to sys_user table and filter 

active=true AND role=itil 

[Musab Rasheed]

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