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

[shaik_irfan]

Hi,

We have a request to pull a report of itil users, we exceeded with the limit of license we have, so we need to monitor it thoroughly and remove itil licenses.

1) We pull a report of users who never logged in servicenow

2) We pull a report of user who did not logged servicenow past 1 month

But my client would like dig deeper on this, 

1) My client wanted to see ITIL Licensed Users broken down by number of days since they last "used" their license?

2) ITIL Licensed Users broken down by any other objective, measurable metric that can be use to round up and remove licenses

[cynlink1]

@ShaiK - Did you implement Eeson's suggested solution? If yes, would you be willing to share the specifics with me?