Page History

...

You can query the database for additional usage data using the UI or at a command line, as described below. The reference to the MySQL database is stored in htdocs/application/data/sql/database_structure.sql.

...

1. Log into License Statistics as an administrator.
   Click Administration at the top of the License Statistics page.
   
   
2. From the Administration page, click the SQL Console tabSelect the SQL Console page under the Administration section in the left navigation pane. 
   
   
3. Enter your SQL query in the "Execute SQL Query" text box and click Execute to generate the report.
   Query results appear in the area below the "Execute Query" text box.
   The results will be returned in a grid only if you enter a query that returns data; e.g., eg. SELECT or SHOW.

You can export the data returned from the query by clicking on one of the options under Save As at the bottom right of the Query 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.

...

You can save SQL queries under the Saved Reports Queries area so that you can easily run the query in the future.

To save a query for future use:

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

...