Skip to main content

SQL Reports

Scott O'Reilly
  • Updated

Basics

SQL Reports allow you to write raw SQL against a database that you have set up in Admin > Import Connections. To create a SQL report, click the "New Report" button.

2021-07-21_10-53-32.png

If you have the correct permissions, choose SQL for the report type.

2021-07-21_11-03-42.png

And write SQL against the database.

2021-07-21_11-05-18.png

SQL reports appear the same as other reports, except they can’t have advanced formatting.

2021-07-21_11-05-52.png

Example SQL

You can include the following text in your SQL queries.

  • [calendar-period-id]
  • [calendar-period-start]
  • [calendar-period-end]
  • [organization-id]

In this example we’re referencing both the calendar period start date and end date to see all of the failed logins during the current period.

2019-10-30_00-53-44.png

Here are the report results for August 2019. You can see there were three failed logins.

Screen_Shot_2019-10-30_at_12.53.57_AM.png

When you change the calendar period selector to September 2019, the SQL report shows different results.

2019-10-30_00-54-58.png