Dotazy na tabulku OTelLogs

Pro informace o použití těchto dotazů v portálu Azure viz tutoriál Log Analytics. Informace o rozhraní REST API najdete v tématu Dotaz.

Analýza závažnosti protokolu

Analýza distribuce protokolů podle úrovně závažnosti a služby za poslední hodinu

OTelLogs
| where TimeGenerated > ago(1h)
| summarize 
    LogCount = count(),
    UniqueTraces = dcount(TraceId),
    UniqueSpans = dcount(SpanId),
    SampleBodies = take_any(Body, 3)
    by ServiceName, SeverityText, SeverityNumber
| extend SeverityLevel = case(
    SeverityNumber <= 4, "Debug",
    SeverityNumber <= 8, "Info", 
    SeverityNumber <= 12, "Warn",
    SeverityNumber <= 16, "Error",
    "Fatal"
)
| order by SeverityNumber desc, LogCount desc
| project ServiceName, SeverityText, SeverityLevel, SeverityNumber, LogCount, UniqueTraces, UniqueSpans, SampleBodies
| limit 100