Creating License Manager Use Reports - Windows Only
Sentinel RMS provides the ability on Windows computers to use Microsoft Access 97 to create graphical reports of License Manager use. To use this feature, you will need to use the lsusage -c option to create a comma-separated values (CSV) file from the License Manager log file.
The following fields appear in the usage log in CSV format. Refer to Contents of the Usage Log for description of these fields:
>Feature name
>Feature version
>Day of week
>Date
>Time
>Transaction ID
>Keys out
>Lifetime
>Username
>Client’s hostname
>License Manager version
>Number of tokens
>Log string
>Qkey ID
>Absolute position
>Group position
>Group name
>Time stamp
>Client ID
NOTE You must have Microsoft Access 97 on the computer on which you want to run reports. Also, keep the number of features for which you are generating reports to a reasonable number (15 to 20) or the reports may not be very easy to read because there simply won’t be room for a clear display.
1.Within Microsoft Access, open the MDB file provided with Sentinel RMS Development Kit: ReportDB.mdb.
2.Select the Table tab.
3.Click New.
4.Select Import Table.
5.Select the CSV file you created with lsusage and click Import.
NOTE In Microsoft Access, not all file types are installed by default. If you do not have the text file type installed, run the Access Setup program, click Add/ Remove, then select Data Access and Change Option to install the text file type.
6.The Import Text Wizard is displayed. Continue to click Next until it asks “Where would you like to store your data?”
7.Select In an existing table and select the table Lservlog. (If instead of adding to an existing Lservlog table you want to create a new one, delete any rows that are already in the Lservlog table before importing new data.)
8.Click Finish. Don’t forget to keep the table name set to Lservlog.
Once the log file use data is imported into the Lservlog table as discussed above, you can now create reports for that data.
1.Within Microsoft Access, open the ReportDB.mdb file. You will immediately see the Sentinel RMS Development Kit report selection screen.
2.You can now select the date range of the report by specifying Start Date and End Date.
3.Now select the type of report you want to create.
NOTE The "per user" and "per host" versions of the reports mentioned below also exist.
•Total Tokens Granted Per Feature: This report demonstrates the total number of license tokens granted in the specified date range for each feature.
•Maximum Tokens Granted Per Feature: This report demonstrates the maximum number of token granted for a feature in a single request done specified date range.
•Average Tokens Granted Per Feature: This reports the average number of feature tokens granted for date range on the basis of minutes/hours/days/weeks.
•Total Minutes Used Per Feature: This report demonstrates the total time (in minutes) each feature was used in the specified date range.
•Total No. Of Tokens Denied Per Feature: This report demonstrates the total number of license tokens for which request was denied in the specified date range.
•Percentage Tokens Denied Per Feature: This report demonstrates the percentage of tokens for which request was denied in the specified date range. This percentage is calculated over total number of tokens requested per feature.
NOTE When using lsusage to create the CSV file that is the input to these reports, you can limit the data to usage information for specific features and versions.