Queries for the WVDErrors table

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

Top 10 connection errors

Returns the top 10 deployment-side connection errors by user count.

// You can replace "UserName" in the query by "CorrelationId" to see how many connections each error has impacted.
// The "CorrelationId" is unique for each connection attempt. 
// The flag on "ServiceError" helps to focus on issues that are most likely mitigated by the administrator or end user.
// Change the ActivityType based on the type of issues you are troubleshooting. 
WVDErrors 
| where ServiceError == "false" 
| where ActivityType == "Connection"  
| summarize UserCount = dcount(UserName), SampleMessage = take_any(Message) by CodeSymbolic
| project SampleMessage, UserCount 
| top 10 by UserCount desc
// Go to https://aka.ms/wvdgetstarted and review additional guidance for diagnostics in the How To section.
// Our troubleshooting guidance has information on escalation paths.

Top 10 feed errors

Returns the top 10 deployment-side feed errors by user count.

// You can replace "UserName" in the query by "CorrelationId" to see how many feed refresh attempts each error has impacted.
// The "CorrelationId" is unique for each feed refresh attempt. 
// The flag on "ServiceError" helps to focus on issues that are most likely mitigated by the administrator or end user.
// Change the ActivityType based on the type of issues you are troubleshooting. 
WVDErrors 
| where ServiceError == "false" 
| where ActivityType == "Feed"  
| summarize UserCount = dcount(UserName), SampleMessage = take_any(Message) by CodeSymbolic
| project SampleMessage, UserCount 
| top 10 by UserCount desc
// Go to https://aka.ms/wvdgetstarted and review additional guidance for diagnostics in the How To section.
// Our troubleshooting guidance has information on escalation paths.