The information on this page refers to License Statistics |
v5.14. If you are running an older version of License Statistics, see documentation for versions previous to |
| Warning |
|---|
As of v5.14, due to significant changes in database structure, we are not able to deliver backward compatibility for custom queries saved in SQL Console. Saved queries may stop working after upgrading to License Statistics v5.14, and they will have to be removed or adjusted to accommodate the new structure. |
You can query the database for additional usage data using the UI or at a command line, as described below. The table reference to the MySQL database is stored in mysqlhtdocs/application/data/sql/database_structure.sql.
Generating SQL reports using the UI
...
- Log into License Statistics as an administrator.
- Click Administration at the top of the License Statistics page.
- From the Administration page, click the SQL Console tab.
- Enter your SQL query in the "Execute 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 SELECT queryquery that returns data, 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.
| Warning |
|---|
...
Use caution when running queries that use UPDATE or DELETE keywords, because using these keywords can cause data loss or corruption. |
Saving a query
You can save SQL queries under the Saved Reports area so that you can easily run the query in the future.
...