Find users with ServiceNow licence users who have not used it

sable
Mega Contributor

‎10-29-2017 08:22 PM

Good morning,

I am trying to find out if there is a way to find users who have a license assigned in ServiceNow who have never actually utilised that license (or not used it for a period of time).

We are nearing our license capacity and have anecdotal evidence to show that numerous licenses are not actually being used and could be used better elsewhere, but we are not sure how to show this (if at all)

Thanks,

Kris.

0 Helpfuls
  • 2,087 Views
6 REPLIES 6

conanlloyd
Giga Guru

‎10-29-2017 08:31 PM

I had the same requirement.   I use this Itil Activity Report from the ServiceNow Share.   I run it and then filter the results as follows:


  • Last Activity {Relative} {on or before 60 days ago} OR
  • Last Activity {is empty}


This shows me all folk with itil role who have not edited any tickets/really done anything other than look around in the last 60 days.   We then remove their itil role.


Hope that helps.


sable
Mega Contributor
In response to conanlloyd

‎10-29-2017 08:32 PM

Thanks Conan, I will try this and report back.


0 Helpfuls

conanlloyd
Giga Guru
In response to sable

‎10-29-2017 08:41 PM

Let me know if you have any questions.   I follow the same 3 steps every Friday:



  1. Clear all entries in the Itil Report Table so I get a fresh list.
  2. Execute the job to populate the table (can take an hour or 2 depending on your data)
  3. Click the favorite I made to the Itil Report Table with the filter I specified above already run
  4. Remove roles from all users listed, except for a couple service accounts that frequesntly show up.
0 Helpfuls

Ketan Mittal1
Kilo Contributor

‎01-06-2022 10:10 AM

Hey Conan, Can't find the report you have shared here. Do you still have it or with some modifications ?

0 Helpfuls