Queries for the SignalRServiceDiagnosticLogs table
For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.
Client connection IDs
Summary of the connection IDs which are client connections.
SignalRServiceDiagnosticLogs
| where ConnectionType == "Client"
| summarize count() by ConnectionId, _ResourceId
Connection close reasons
Summary of close reasons for disconnected connections.
SignalRServiceDiagnosticLogs
| where OperationName == "ConnectionAborted" or OperationName == "ConnectionEnded" or OperationName == "EndConnectionFailed"
| summarize count() by ConnectionId, Message, _ResourceId
IP addresses
Summary of Ips that connected to the service, which is useful to figure out whether same issue has pattern in IP address.
SignalRServiceDiagnosticLogs
| where isnotnull(CallerIpAddress) and isnotempty(CallerIpAddress)
| summarize count() by CallerIpAddress, _ResourceId
Logs relating to specific connection ID
A list of logs which contains specific connection ID.
SignalRServiceDiagnosticLogs
// Enter ConnectionId value to filter by specific connection ID.
| where ConnectionId == ""
| sort by TimeGenerated asc
| take 100
Logs relating to specific message tracing ID
A list of logs which contains the specific message tracing ID.
SignalRServiceDiagnosticLogs
| where OperationName == "ConnectionAborted" or OperationName == "ConnectionEnded" or OperationName == "EndConnectionFailed"
| summarize count() by ConnectionId, Message, _ResourceId
Logs relating to specific user ID
A list of logs which contains the specific user ID.
SignalRServiceDiagnosticLogs
// Enter UserId value to filter by specific user ID.
| where UserId == ""
| sort by TimeGenerated asc
| take 100
Logs with warning or exceptions
A list of logs which contains warnings or exceptions (latest logs shown first).
SignalRServiceDiagnosticLogs
| where Level == "Warning" or Level == "Error"
| sort by TimeGenerated desc, Collection asc
| take 100
Server connection IDs
Summary of the connection IDs which are server connections.
SignalRServiceDiagnosticLogs
| where ConnectionType == "Server"
| summarize count() by ConnectionId, _ResourceId
Time chart of operation names
Chart of operations in time, for getting the trend of the connectivity and messaging events.
SignalRServiceDiagnosticLogs
| summarize count() by OperationName, bin(TimeGenerated, 1min)
| render timechart
Transport types
Summary of transport types for connections. Usually Websockets should be the majority by default.
SignalRServiceDiagnosticLogs
| where isnotnull(TransportType) and isnotempty(TransportType)
| summarize count() by TransportType, _ResourceId
User IDs
Summary of the user IDs.
SignalRServiceDiagnosticLogs
| summarize count() by UserId, _ResourceId