Setting the file. One moment.
Chapter 15 · Azure Diagnostics
Subchapter 15.5
references/kql-queries.mdMarkdown1 KBView on GitHub
Essential Kusto Query Language (KQL) queries for diagnosing Azure application issues.
// Recent errors
AppExceptions
| where TimeGenerated > ago(1h)
| project TimeGenerated, Message, StackTrace
| order by TimeGenerated desc// Failed requests
AppRequests
| where Success == false
| where TimeGenerated > ago(1h)
| summarize count() by Name, ResultCode
| order by count_ desc// Slow requests
AppRequests
| where TimeGenerated > ago(1h)
| where DurationMs > 5000
| project TimeGenerated, Name, DurationMs
| order by DurationMs desc// Dependency failures
AppDependencies
| where Success == false
| where TimeGenerated > ago(1h)
| summarize count() by Name, ResultCode, TargetTimeGenerated > ago(Xh)take 50 for large datasetssummarize to aggregate data before analyzing