Managing SPM license allocation

[KhoendibG]

We have recently deployed SPM in our environment and I am a new SysAdmin for SPM. I was wondering if there is a way to report on the last time someone 'logged into SPM'? We have reached our license limit, but we believe there are some people who have SPM access but have never logged in and would like to harvest those licenses. We use ServiceNow for a host of service, like Service Requests and Incident Management, so using the time time a user logged in won't give us an accurate indication of when a user last 'used' SPM - as they might have raised a Service Requests or Incident. So my question is, is there a way to report on the last time a user logged into SPM? 

[PaulaaO · Accepted solution]

Hiya - I have a similar role as you 🙂

My approach is to mix the last logged in date with the usage reports which focus on the applications within SPM and that's how I challenge users who are not using their SPM licence. Might worth mentioning that I extract this data from SN but manipulate data outside SN in Excel 🙂

a.  I run a report on sys_user_has_role to identify those that have roles that would occupy an SPM licence

b. I run a report on ua_app_usage, I have added my filters should you find them helpful. We're using 90 days as that's our internal agreed timeframe to review activity, but you can change that of course. The tricky part I found and took me a while to clarify is the App list. I had to ask ServiceNow via our Account manager only because the terminology is not consistent across the platform (if you check the Apps within a Licence type in the Subscription Management you won't be able to match it with the names from the reports)

b* there is also a table called licensed_app_usage which should offer very similar info with the one above. The reason I'm using the other table is because it allows reporting on custom tables which this one doesn't, but you can use it if you don't have custom tables in SPM space.

Hope this helps 🙂 Good luck, it's not the easiest tasks