Reporting on Service Now License Usage

[Dan Spada]

Hi all,

I have developed a small customisation in Service Now to look at not only currently licensed users, but also the maximum logged in users by day, and concurrent connections by day. It tracks it by day so that we can see license usage over time so that we can plan for growth, as well as see actual usage of licensed users and have this presented within the reporting area of Service Now.

You can view a screenshot, and get all the required code to get this up and running on my blog:
http://danspada.com/2012/10/reporting-on-service-now-license-usage/


I have seen similar scripts to this elsewhere on the Service Now forum, however my version contains more information which helps identify peaks over time.

Any thoughts? Suggestions? Improvements?

[Dan Spada]

Hi guys,

I took my website down a while ago, glad to see that this code is still used! Thanks for the tweaks, Shawn!

Dan.

[robpickering]

Shawn, nicely done.   Should have though of that myself.   Nothing on the Internet is ever really "gone".   Thanks for our new permanent archive.

[Shawn Dowler]

It has come to my attention that the v_user_session table may only contain users logged in from one node. This could make this solution underreport usage. I'm looking for confirmation one way or the other that this table contains accurate information for reporting on an instance with more than one node.

[Dale Hynes]

I was looking at that exact same issue a few months ago, then got busy with our Helsinki upgrade - looks like the multi-node issue was solved in either Geneva or Helsinki (we went from Fuji to Helsinki). Can you tell when ?