Is there a way I can tell when (on which date) an ITIL license had been granted to a user?

[chankf]

Is there a way I can tell when (on which date) an ITIL license had been granted to a user?

I'm trying to find out how many new licenses from our existing pool had been newly allocated since the start of the current year by looking at the "license allocated" date.

[Eric W · Accepted solution]

I think the sys_user_has_license table has what you need.

Subscription Overview > <License (e.g. IT Service Management - Fulfiller User v2)> > Subscribed Users

The created field indicates when the user was subscribed to the particular license.

If your definition of "ITIL licenses" is different from the license_details (subscription) record through which the itil role is licensed, I'm not sure how to answer that.

[chankf]

Is there a way to view the allocation history for a period of let's say the past 2 years instead of just the current year? (see attached screenshot)