Queries

How to run a dynamic SQL query from the admin reports area

Dynamic SQL Query

Go to: (depending on the environment):

• https://global.insite.com/admin/reports/queries/sql

• https://sandbox-global.insite.com/admin/reports/queries/sql

• https://dev-global.insite.com/admin/reports/queries/sql

You should see something like this:

In the large Text Area insert the SQL Code:

And click Execute

Results for the SQL Query will display in the Results panel.

If you scroll right you will notice column names:

To download the Query results, click on the Download button in the Results panel.

Example: Assessment Attempts

select * from logs.Change where AggregateIdentifier = 'INSERT ASSESSMENT ATTEMPT UNIQUE IDENTIFIER' order by changetime desc

OR

select * from logs.Change where AggregateIdentifier = 'INSERT ASSESSMENT ATTEMPT UNIQUE IDENTIFIER'