Page History

...

1. Log into License Statistics as an administrator.
   
   
2. Select the SQL Console page under the Administration section in the left navigation pane. 
   
   
3. Enter your SQL query in the "SQL Query" text box and click Execute to generate the report.
   
   The results will be returned in a grid only if you enter a query that returns data; e.g., SELECT or SHOW.If desired, click Save to save the query. A dialog will allow you to name the query. You can also edit the query if needed by changing the entry in the SQL Query edit box.
   Image Removed
   After saving the query, it will be available from the Saved Queries grid.
   Image Removed
   

Exporting query data

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.

...

Saving a query

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:

1. Click Add under the Saved Queries area.
2. Enter a name for your saved query in the Query 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 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.

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.

Running a SQL query from a command line

...