Skip to content

KQL Query Library

A collection of pre-built KQL queries for analyzing and troubleshooting ACS activities in Log Analytics.

Categories

Category Description Overview
SMS Delivery tracking, error analysis, and rate limiting logs. SMS KQL Overview
Email Bounces, domain verification, and delivery performance. Email KQL Overview
Chat Latency, message delivery, and thread activity analysis. Chat KQL Overview
Voice/Video Call quality, media performance, and call drops. Voice/Video KQL Overview
General Resource-level diagnostic events and summary logs. Detector Map

Quick Queries

Best Practices

  • Filter by Time: Always include TimeGenerated > ago(1h) to limit the query scope and improve performance.
  • Join Tables Carefully: Use join sparingly, especially on large tables like ACSCallDiagnosticsEvents.
  • Use Summarize: Group data by relevant fields (e.g., ResultSignature, Status) to identify common failure patterns.
  • Visualize Results: Use render barchart or render timechart to visualize trends and anomalies.

See Also

Sources