1. Add/modify the following environment variable to enable logging with the License Server. All of the folloiwng is done on the actually license server machine, and not the client, of course.
**LSERVOPTS= -l c:templicense_usage.log -z -2m**
(you can change the directory of the license file if you wish. The 2m limits the size of the file to 2MB, but can be modified)
2. You can export the log once it is enabled, to a CSV file. From a command prompt, navigate to the Utils folder of the license server and run the following command:
**lsusage.exe -l C:templicense_usage.log -c C:QTP_License_Usage.csv**
3. You can then import this CSV file into Excel.
You can find detailed information about the command line switches and what the different License Server environment variables do, but this is a quick summary to get you going.