The SQL Console within the Admin Console allows for admins to run SELECT statements against the product databases. Other forms of SQL are restricted via the console, and there are Restricted characters in Admin Console's SQL Console. The output is limited to 1000 records. Queries with more results will have their results truncated to the first 1000 records.
To access the SQL Console:
- Go to the Infogix Admin Console
- Click on SQL Console within the left-hand navigation:
- Input the SQL to run within the text box and click Execute
- Your query output will display in the bottom pane. Optionally, there is a Generate CSV button in the bottom-right to export results.