Queries for the MySqlAuditLogs table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

Audit general events

Display all GENERAL events from the MySql Audit log.

MySqlAuditLogs
| where EventClass == "general_log"
| order by TimeGenerated desc
| take 100

Audit connection events

Display all CONNECTION events from the MySql Audit log.

MySqlAuditLogs
| where EventClass == "connection_log"
| order by TimeGenerated desc
| take 100