How to find non active ITIL users

hemant10
Kilo Contributor

Hi,

In order to better manage the ITIL licenses, I need to find those ITIL users who have not performed any activity in the system.

Is there an easy way to find this?

5 REPLIES 5

prashantnagaral
Kilo Guru

Hi Hemant,



You can have a query on sys_user_has_role like Role = itil & sys_user.Last login time is more than days, weeks, months or based on your requirement to retrieve the list of ITIL users who has not used Service-Now.



Hit like, Helpful or Correct depending on the impact of the response



Thanks


Prashant


shloke04
Kilo Patron

Hi Hemant,



Navigate to the User Table and give the filter condition as :



1) Roles is itil


2) Last Login Time is "More than" "Days/Weeks/Month/Quarter as shown below:




Last Login.png



Hope this helps. Mark the answer as correct/helpful based on impact.



Regards,


Shloke


Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Dave Smith1
ServiceNow Employee
ServiceNow Employee

Pretty much what Shloke said - you need to clarify what you mean by "have not performed any activity in the system" then create a filter around that criteria.


To be specific, I would like to understand if an ITIL user has performed any activity (e.g updated the worknotes, resolved any tickets etc) on any tickets. If they have not, then we plan to remove there ITIL role and save on license.