MySqlAuditLogs

Audit Logs for Azure Database for MySQL Flexible Servers.

Table attributes

Attribute	Value
Resource types	microsoft.dbformysql/flexibleservers
Categories	Audit, Azure Resources
Solutions	LogManagement
Basic log	No
Ingestion-time transformation	No
Sample Queries	Yes

Column	Type	Description
_BilledSize	real	The record size in bytes
Category	string	Category of log.
ConnectionId	string	Unique connection ID generated by MySQL.
Db	string	Name of database accessed.
ErrorCode	int	Error code if query failed. 0 means no error.
EventClass	string	Class of the log event.
EventSubclass	string	Subclass of the log event.
EventTime	datetime	Query start time in UTC timestamp.
Host	string	Host name of client connecting to MySQL.
Ip	string	IP address of client connecting to MySQL.
IsAadAuth	string	Is AAD auth or not.
_IsBillable	string	Specifies whether ingesting the data is billable. When _IsBillable is `false` ingestion isn't billed to your Azure account
ReplicationSetRole	string	Replication set role of MySQL flexible server.
_ResourceId	string	A unique identifier for the resource that the record is associated with
SourceSystem	string	The type of agent the event was collected by. For example, `OpsManager` for Windows agent, either direct connect or Operations Manager, `Linux` for all Linux agents, or `Azure` for Azure Diagnostics
SqlText	string	Full query text.
Status	int	Status of connection.
_SubscriptionId	string	A unique identifier for the subscription that the record is associated with
Table	string	Name of table accessed.
TenantId	string	The Log Analytics workspace ID
ThreadId	int	ID of thread that executed the query
TimeGenerated	datetime	The timestamp (UTC) of when the log was generated.
Type	string	The name of the table
User	string	Name of user executing the query.