IBM Support

How do I analyze a License Manager usage log file?

Troubleshooting


Problem

My License Manager is configured to generate a usage log file. How do I use this file to analyze license usage of my concurrent/network clients?

Resolving The Problem

The following provides a process for converting a License Manager usage log file to a SPSS Statistics data file that can be used for analysis.

It is not necessary for the files to be located in 'C:\LM_LOG'.

However, the 'Log_File_To_Statistics_Data.sps' file assumes this is the location.

If a location other than 'C:\LM_LOG' is used, change the location of the 'slm_log.txt' file indicated in the following syntax command in the 'Log_File_To_Statistics_Data.sps' file:

/FILE="C:\LM_LOG\slm_log.txt"

  1. Create the following directory: C:\LM_LOG
  2. Save attached syntax file 'Log_File_To_Statistics_Data.sps' (below) to C:\LM_LOG.
  3. Acquire location and name of License Manager usage log file (example: slm_log.txt).
  4. Copy the License Manager usage log file to log file conversion directory C:\LM_LOG.
  5. IF usage log file is not named 'slm_log.txt' change the file name to 'slm_log.txt'
  6. IF the location of the
  7. Open SPSS Statistics.
  8. Open SPSS Statistics syntax file 'Log_File_To_Statistics_Data.sps' in SPSS Statistics.
  9. Select the 'Run' menu.
  10. Select the 'All' menu entry.
  11. The data from the License Manager usage log will converted to a Statistics data file allowing data analysis of License Manager usage.
  12. Select 'Value Labels' under the 'View' menu to see the value labels.


Log_File_To_Statistics_Data.spsLog_File_To_Statistics_Data.sps


The following describes the variables in the SPSS data file resulting from the conversion:

DoW
This variable indicates the day of week the when the license transaction occurred.

Month
This variable indicates the month when the license transaction occurred.

Date
This variable indicates the day of month the license transaction occurred.

Year
This variable indicates the year the license transaction occurred.

FCode
This variable indicates the Product or Product Feature by the product feature code.
Feature codes for SPSS products are:

1200 Statistics Base
1201 Statistics Tables (Original)
1202 Statistics Regression
1203 Statistics Advanced Statistics
1204 Statistics Trends Original
1205 Statistics Exact Tests
1206 Statistics Categories
1207 Statistics Missing Values
1208 Statistics Conjoint
1210 Statistics Custom Tables
1211 Statistics Complex Samples
1212 Statistics Decision Trees
1213 Statistics Data Preparation
1214 Statistics Programmability
1215 Statistics Advanced Visualization
1216 Statistics Forecasting
1217 Statistics Data Adapter
1218 Statistics Neural Networks
1219 Statistics Direct Marketing
1220 Statistics Bootstrapping
1221 Statistics Developer
1320 Visualization Designer
6000 Text Analytics for Surveys 4.0.1
8000 Text Analysis for Surveys 3.0.0
8300 Text Analytics for Surveys 4.0.0
8400 Modeler
9005 Amos (Base)
9503 SamplePower
9800 AnswerTree

ProdVer
This variable indicates the product version.
Product version information is displayed in 'vX0' or 'vXX0' format where X represents the one-digit version number and XX represents the two-digit version number.

Examples:

A value of 'v40' would indicate version 4 of the product indicated in the 'Feature Code' (FCode) variable.
A value of 'v240' would indicate version 24 of the product indicated in the 'Feature Code (FCode) variable.

TranType
This variable indicates the type of license transaction that occurred. The possible transaction values are 'issued' 'returned','denied', 'checkout' and 'checkin'. A value of 'denied' indicates a licensing request was made for a product version of feature for which no more licenses were available at the time of the request. The values 'checkout' and 'checkin' indicate commuter licenses checked out and checked in.

LicInUse
This variable indicates the number of licenses that were in use when after the license transaction (issued/denied/returned).

TimeInUse
This variable indicates the length of time, in seconds, that a license was in use.

UserName
This variable indicates the network user name associated the license transaction.

HostName
This variable indicates the network identifier of the client host machine associated with the license transaction.

LMVer
Version of the License Manager on which the transaction was performed.

[{"Product":{"code":"SSLVMB","label":"IBM SPSS Statistics"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Not Applicable","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSLVC7","label":"IBM SPSS Amos"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Not Applicable","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS3RA7","label":"IBM SPSS Modeler"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Not Applicable","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS6A5A","label":"IBM SPSS SamplePower"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Not Applicable","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS6A7K","label":"IBM SPSS Text Analytics for Surveys"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Not Applicable","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 April 2020

UID

swg21986875