Queries for the OTelEvents table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

Exception events summary

Summarize exception events by type and service over the last 24 hours.

OTelEvents
| where TimeGenerated > ago(24h)
| where isnotempty(ExceptionType)
| summarize 
    ExceptionCount = count(),
    UniqueTraces = dcount(TraceId),
    UniqueSpans = dcount(SpanId),
    SampleMessages = take_any(ExceptionMessage, 3)
    by ServiceName, ExceptionType, ExceptionProblem
| order by ExceptionCount desc
| project ServiceName, ExceptionType, ExceptionProblem, ExceptionCount, UniqueTraces, UniqueSpans, SampleMessages
| limit 100