How to Report on ITIL License Usage vs Inactive Users (30/60/90 Days)

[saint]

Hello Experts,

I’m looking for guidance on creating a report (or dashboard) to analyze ITIL license usage efficiency.

• Identify users assigned an ITIL license
• Compare this against user login activity
• Specifically highlight users who:
  • Have not logged in for 30, 60, or 90 days
• The goal is to determine whether ITIL licenses can be reclaimed or optimized

[Ankur Bawiskar]

@saint 

check these links

ServiceNow licensing / usage reports 

Need help on pulling a report of users when they last used Servicneow itil 

User login-logout statistics/report for an instance 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[saint]

Hi @Ankur Bawiskar 

Thank you for your response. I was able to identify ITIL users who have not logged in over the past 30, 60, or 90 days. I now plan to analyze the users who have logged in to determine whether their activity was related to resolving tickets or limited to actions such as submitting requests through the portal, completing surveys, or performing other non-fulfillment activities. do you know if there's any table that would provide this information.

[Ankur Bawiskar]

@saint 

Thank you for marking my response as helpful.

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[AndersBGS]

Hi @saint ,

you have sys_user_has_role and sys_user which can be dot-walked from sys_user_has_role. Where do you experience issues in creating the report.