Report to show a monthly trend of licenses added to the software license [alm_license]

[Dazler]

Hi,

I am trying to find out if there is a way to create a report that shows the trend for the licenses for software assets?  What they are wanting is to see the growth of the licenses for each of the software assets.  For example, last month there were 300 licenses for adobe acrobat and the this month there were 350 licenses.  They want to be able to see that license historically.  Basically if the field for the licenses change.

Does anyone know if that is possible?

Any help would be appreciated.

[Abhay Kumar1]

@Dazler As per my understanding,Yes, it is possible to create a report that tracks the trend in software asset licenses over time in ServiceNow. To do this, you’ll need to leverage Metrics to capture and report on the changes in license counts.

Hope this will help you.

[Dazler]

@Abhay Kumar1 ,

Thank you for replying back.  I am new to leveraging metrics for reports.  Do you have any advise to get me started?

[B_Engelstock]

I would make it this way, which is simple:

1. Create a new custom table with the fields required for your individual report dates (date, license name, count).

2. Create a scheduled script that runs monthly on last dary in the month, which will collect the data from your software asset table(s). Use GlideAggregate to get the COUNT, etc that you need in the custom table and insert the results in that table. One record will the be created in that table every month. You can run the scheduled script on-demand to test it when you build it.

3. Create a report based on the custom table, that show the license count month by month.

4. Publish the report (maybe on a dashboard) and remember to set the report ACL for the audience (groups, roles).

5. Use Archive/Destroy to purche old records from the custom table, to avoid having the table to build up with old data, which is not used.

[Abhay Kumar1]

It is not right way to go for customisation when we have OOB functionality to achieve the same.