The information on this page refers to License Statistics v6.0 and newer, which introduced a new user interface (UI). If you are using a version previous to v6.0, see documentation for previous versions. |
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.
To run a SQL query on the License Statistics database using the UI:
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.
Use caution when running queries that use UPDATE or DELETE keywords, because using these keywords can cause data loss or corruption. |
The default query limit is 1000 rows. It can be overwritten using LIMIT keyword in the SQL statement. |
You can save SQL queries under the Saved Queries area so that you can easily run the query in the future.
To save a query for future use:
You can also save a query as a CSV, Excel or PDF 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.
To run a SQL query from a command line: