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

chankf · ‎09-08-2022

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 · ‎09-09-2022

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.

View solution in original post

Jaspal Singh · ‎09-08-2022

Hi,

Did you check for user role (sys_user_has_role) table?

You can filter by Role & user & check for Created date.

So, if user is assigned to a group that inherits ITIL on 01/01/2022 it will show Created date time as 01/01/2022 ... . If user is added to another group that inherites ITIL on 01/09/2022 then the created date time will remain same i.e. 01/01/2022 but the inheritance count will be incremented.

Community Alums · ‎09-08-2022

HI @chankf ,

if you're trying to simply view this within the platform without scripting and all that, then you can...

You'd need to navigate to:

User Administration > Roles, then select the itil record
Within the inherited column, right click on any record that says: true and choose "filter out", or false and choose "show matching"
Any record remaining where it says inherited = false, means they have the role directly applied to them, click the user record, look at the roles related list, click edit, and then you can remove and add them to a group where they inherit it properly.

Also, check this article :https://community.servicenow.com/community?id=community_article&sys_id=c2455fcddb875744feb1a851ca961...

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

chankf · ‎09-08-2022

Hi

Your method doesn't really answer my question which is really about "How many new ITIL licenses had been allocated in the current year?".

I'm not looking for a count of how many ITIL licenses are currently allocated in total.

Prabhu6 · ‎09-14-2023

Hi Sandeep,

How do we know the Total ITIL licensing details part of the subscription?

In the Subscription overview, I can see below details for ITSM, ITBM, Discovery etc same like I am looking for ITIL..do we have the option?

PurchasedSort

AllocatedSort

Type

Thank you

Prabhu