0

can anyone suggest how to create the logic app for failed connections in azure to send mail automatically, diagnostics setting in logs log analytics enabled, for failed connection need how many failed connections with username and ip address.

AzureDiagnostics

| where event_class_s == "connection_log"

and event_subclass_s == "DISCONNECT"

also need to automate through logic app for slow running queries in mysql server any suggestions.

luck_26
  • 7
  • 4
  • Please consider viewing the following URL - https://www.percona.com/blog/2012/12/28/auditing-login-attempts-in-mysql/ - for some ideas on how to begin achieving your goal of dealing with failed connections. – Wilson Hauck Apr 22 '22 at 13:08
  • This is from mysql server how can i run it from azure level and get the result, Diagnostic settings already enabled – luck_26 Apr 22 '22 at 16:51
  • what have you tried / search so far ? you probably want to create an alert that will trigger the logic app ? or having a time trigger running x minutes ? – Thomas Apr 23 '22 at 03:19
  • yes from mail alert we should get long running queries mysql, and failed connections from logic app – luck_26 Apr 23 '22 at 04:02
  • Please post last 100 TEXT lines from your error log for us to review your 'failed connections', please. And post last 100 TEXT lines from your Slow Query Log, please. – Wilson Hauck Apr 23 '22 at 13:45
  • What is your actual issue? you dont know how to write the KUSTO query or you dont know how to write the logic app or both? – Matt Douhan Apr 29 '22 at 18:36
  • Logic app how to configure and send mail automatically – luck_26 Apr 30 '22 at 01:02

0 Answers0