Forum Discussion

Syed_Aman's avatar
Syed_Aman
Copper Contributor
Apr 18, 2019

Azure Log Analytics for Azure MySQL database (PaaS Service)

Hello Everyone, I need some help in the below issue: I have enabled the diagnostic setting for Azure MySQL database (PaaS Service) in our environment and configured the alert to send the logs to Azur...
azure monitor
Query Language
CliveWatson's avatar
CliveWatson
Former Employee
May 13, 2019

Hi Syed_Aman 

I don't have any DBforMYSQL records 

 

AzureDiagnostics
| where SubscriptionId != ""
| where TimeGenerated > ago(10m)
| where ResourceProvider == "MICROSOFT.DBFORMYSQL"
| where Category == "MySqlAuditLogs" and event_class_s == "connection_log"
| summarize count() by  event_subclass_s

 

The above should enable you to see what other states, like 'failed' have occurred - sorry I don't have the data so this is a guess!

 

 

Resources