UFT/QTP Concurrent License utilization Log file generation

Unlike ALM users administration from SiteAdmin, UFT concurrent users administration is not so user friendly. There is not direct option to administrate users of UFT who are using licenses currently.

Following steps can help us who is using when. We can share this report to management, so that it allows offline administration on the available licenses.

Please follow in below steps for QTP Concurrent Licenses utilization Log file generation:

Step 1.  Install all the utils for Sentinal from QTP/UFT software

Step 2. Search for lsusage.exe (thats what we would use to convert our log to CSV format)
(Assume its at C:\Documents and Settings\"User"\LicenseUtils\lsusage.exe

Step 3. Open Command prompt navigate to C:\Documents and Settings\"User"\LicenseUtils

Step 4. Type in lsusage.exe -l C:\Windows\system32\lservsta -c C:\results.csv and hit return
Verify C:\results.csv has been created.

Step 5. Insert the following headers to the csv starting from Cell  A1 through to Cell Q1
FeatureName Version DayOfWeek DateOfTrans TimeOfDay LoggingType KeysInUsed UsageTime UserName HostName LmLibVer NoOfLicenses ClientLockedStr QueueKeyId AbsPos GrpPos
GrpName and save it.

Step 6. Column G KeysInUsed represents the number of concurrent licenses at any specific time frame within the log.

Step 7. Open the ReportDB.mdb file from the utils folder.

Step 8 import Results.csv
( Tables>>New>>Import Table>>OK>>Browse to C:\Results.csv
(You would need to select Text files from the  Files of type dropdown)
>>IMPORT Select Delimited>>Comma>>check First Row Contiains Fiels names>>Ina a new Table>>Next>>Let Access choose..>> name the table as "LServlog">>Finish