How to find non active ITIL users
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2017 01:47 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2017 02:03 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2017 03:42 AM
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:
Hope this helps. Mark the answer as correct/helpful based on impact.
Regards,
Shloke
Regards,
Shloke
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2017 04:32 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2017 04:37 AM
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.