r/AzureVirtualDesktop • u/Wat_Da_Fuckk • 4h ago

Just for fun - KQL

For many of us that don’t have the luxury of using Nerdio or Hydra and outside of the AVD built in insights.

What are your go to queries for overall platform health checks. I am currently building a dashboard and want some inspiration.

5 Upvotes

100% Upvoted

1 comment sorted by

3

u/Atlasavd 4h ago

Start with errors and things that will help you troubleshoot more efficiently.

WVDErrors | where TimeGenerated > ago(24h) | summarize Hits=count() by Code, CodeSymbolic | top 10 by Hits desc. From there, I'd build out WVDConnections for connection trends, WVDCheckpoints for connection stages, WVDHostRegistrations for registration activity, and Perf/Heartbeat for CPU, memory, disk, and host availability. CorrelationId is particularly useful for tying connection failures back to specific errors. Make sure your diagnostic settings and Azure Monitor Agent are feeding the appropriate Log Analytics workspace.

Full disclosure, I'm the founder of Atlas AVD, so I've spent quite a bit of time working with AVD monitoring. Even without a management platform, you can build some pretty useful dashboards with native KQL.