SQL Reports

SQL Reports allow you to write raw SQL against a database that you have set up in Admin > Import Connections.

You can include the following text in your SQL queries.

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

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.

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

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