Queries for the SignalRServiceDiagnosticLogs table
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
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for