How to use OpenLM for creating billing reports?

OpenLM is a license statistics application for FLEXnet (FLEXlm) and also a replacement for Macrovision SAMsuite and SAMreport. The software allow you to produce monthly usage reports and use them in order to create your bills for users and projects.

This article will demonstrate EasyAdmin capability for creating billing reports using Simens NX UGS license statistics.

In order to produce the report open OpenLM EasyAdmin which is the system interface for FLEXnet reports. Go to the user activity TAB to see the following interface:

Fill in the range you would like the report to cover and click view. Then Export the data by clicking "Download CSV".

You can open the CSV file with your spreadsheet software or any other software in order to calculate the usage time. Each exported row looks as follow:

The date/time format is UNIX time stamp (milliseconds from 1970). We would like to calculate the work time in minutes so we will add a new column with this formula:

= (F1-E1)/60000

The value is the number of minutes that the user have used the product.

The next release of OpenLM will feature a ready made billing report with totals for each user.

If you want to display the start and end date in a date format you can use this formula (translate UNIX time stamp to Excel Date):

= E1 / 86400 + 25569

Then change the cell format to the desired date/time format (for example this custom format: mm/dd/yyyy h:mm).