Page History

You can query the database to get a custom usage report for additional usage data using the web-based UI or at a command line, as described below. The table reference to the MySQL database is stored in mysql/database_structure.sql.

Generating

...

SQL reports using the

...

UI

To run a SQL query on the License Statistics database using the web-based UI:

1. Log into License Statistics as an administrator.
   
   
2. Click Administration at the top of the License Statistics web page.
   
   
3. From the Administration page, click the SQL Console tab. 
   
   
4. Enter your custom SQL query in the edit "Execute Query" text box and click Submit Execute to generate the report.
   The Custom SQL Report appears
   Query results appear in the area below the "Custom SQL Execute Query" edit text box. Query The results will be returned in a grid only if you enter a SELECT query.

You can export the data returned from the query by clicking on one of the Download options under Save As at the top bottom right of the Custom SQL ReportQuery Results grid. For example, you may want to view the report in Excel or PDF so you can include it in a report or presentation. See Downloading License Statistics data for more information about obtaining data in various formats.

...

1. Click Add New under the Saved Reports area.
2. Enter a name for your report in the Report Name field.
3. Enter the SQL query in the SQL query field.
4. Click Save to save the query.
5. To run the saved query, click on it the Run icon in the Saved Reports listAction column for that query. The query appears in the Custom SQL Query area.
   
6. Click Submit Execute to submit the query.

You can also save a query as a CSV, Excel or PDF  file file using Save As in the Saved Reports area. After selecting the format to which to save the file, you are prompted to either open or save the file.

...