• Created by Unknown User (mkos), last modified on Sep 09, 2016

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

How does License Statistics run?

License Statistics runs as a service on Windows and as a daemon on Linux.

For more information, see Running License Statistics.

What is the difference between License Statistics realtime usage and imported usage reporting?

Imported usage reporting lets you import and review log files from a number of license servers, whereas realtime usage reporting allows you to collect realtime data from the license server at configurable time intervals.

Since imported usage reporting doesn't require a connection to the license server, it can be used for:

  • Billing purposes, where the license servers are at the customer's site and License Statistics software is at the vendor's site, making this feature especially helpful for companies that do back-billing or pay-per-use billing.
  • Analyzing data from remote license servers in departments that run on separate networks.

For more information, see License Statistics Overview and Features.

Is License Statistics license usage data reliable?

With License Statistics, you can import existing data from a number of supported log files, including FlexNet (encrypted) report logs. The imported data is 100% accurate and can be used for reliable billing.

License Statistics in real-time mode uses data sampling to gather statistics, which will have small inaccuracies. However, over time, you can easily see a trend, and for most real applications (where users use the application for hours), the results average out. So, while License Statistics' data sampling method is not strictly speaking 100% accurate, it provides real-time reporting and flexibility, and can be run on virtually any license manager.

Can I install the License Statistics on a Linux machine and view results on a Windows machine?

You can access all License Statistics data for all monitored applications from an online, easy-to-use UI.

Running an SQL query on the License Statistics database

You can obtain custom reports of license usage information by running a SQL query on the License Statistics database, using either the License Statistics UI or a command line.

For more information, see Generating custom SQL reports.

Extending License Statistics reports with LDAP information

This tutorial takes you through the process of enhancing your existing reports with helpful information from other data sources. This is useful when you want to generate more descriptive, user-friendly reports. To do that, you need to be familiar with Microsoft Excel or LibreOffice Calc.

The following steps are designed to extend the Usage Per User report with LDAP information.

  1. Log into License Statistics.
  2. Select the Usage Per User tab from the Reports page.
  3. Prepare sample data to be used in your report and make settings (for example, filters). Note that the data needs to be sorted alphabetically.
  4. Download your report in the CSV format using the Save As button.
  5. Export information about users by clicking the SQL Console tab in the Administration page.
  6. Paste and run the following query:
    SELECT U.Name, CONCAT_WS(" ", FirstName, LastName) as Fullname FROM UserDetails UD INNER JOIN User U ON UD.UserId = U.Id ORDER BY U.Name
  7. Output the result to the CSV format.
  8. Paste these two reports in two separate Excel spreadsheets in one Excel file. To do this, you can simply open the exported Usage Per User report and copy LDAP information to another spreadsheet.

  9. Move back to the first sheet, add a new header named "User Details" and paste a VLOOKUP function to every field in this column.
    (Note that the syntax of the function may vary depending on whether you're using Excel or LibreOffice Calc.). For example, for Excel 2013 you may use the following syntax:

    =VLOOKUP($B2;Sheet2!$A$1:$B$7;2)

    where:

    • VLOOKUP is a function that performs a vertical lookup by searching for specific information located in a sorted table.

    • Column B from Sheet1 contains username and number 2 indicates the number of the current row.

    • Range of data indicates data that will be used by VLOOKUP, using cells from column B.

    • Number 2 indicates the column from Sheet2 for which the matching value must be returned (in this case user's first name and last names).

  10. If everything goes well you will see a final result similar to the following:

    If you think that this situation can be a common occurrence, don't hesitate to inform us using our feedback portal.


 

  • No labels