Page History

...

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 box and click Submit to generate the report.
   
   The Custom SQL Report appears in the area below the Custom SQL Query edit box. Query results will be returned in a grid only if you enter a SELECT query.

...

To save a query for future use:

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 in the Saved Reports list. The query appears in the Custom SQL Query area.
   
6. Click Submit to submit the query.

You can also save a query as a CSV, Excel, PDF or SQL 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.

...