Edit

Share via


Queries for the DurableTaskSchedulerLogs table

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

Recent Errors

Shows the most recent error and critical log messages.

// Recent Errors
// Shows recent error messages
DurableTaskSchedulerLogs
| where Level < 3  // Error and Critical
| project TimeGenerated, TaskHub, OperationName, Log
| sort by TimeGenerated desc
| take 100

Worker Connection Summary

Simple view of worker connections and disconnections by TaskHub over time.

// Worker Connection Summary
// Simple view of worker connections by taskhub
DurableTaskSchedulerLogs
| where OperationName == "WorkerConnected" or OperationName == "WorkerDisconnected"
| summarize 
    Connected = countif(OperationName == "WorkerConnected"),
    Disconnected = countif(OperationName == "WorkerDisconnected")
    by TaskHub, bin(TimeGenerated, 1h)
| sort by TimeGenerated desc