3 steps to complete.
The SQL Manager is used to improve the standard reporting that exists in Corporate Office. To ensure that the live database performance will not be impacted, all queries run through the SQL Manager will run off a replicated database (the same that’s used for fail-overs).
Read more: 6.4. Using the SQL Manager to View Data
In Corporate Office, navigate to: Reports > SQL Manager.
In the SQL Query box, type your SQL statement.
For examples of SQL queries, see: SQL Query Library
You can click the Table Schema link to view a list of all available tables you can click and use in queries.
Tip: Click in the Query Box and press CTRL+SPACE on your keyboard to enable SQL Type-Ahead
Click the Run button to view the query.
The query results will display under Query Results.
Click the Save button to save your query.
Step-by-step guide: How to Save a Query in the SQL Manager
Click the Export button to export the query results in .CSV format.
You now know how to use the SQL Manager to view a query.