Hi @SaiPavanKumar
The Azure Virtual Desktop (AVD) Insights dashboard you’re referring to in the Azure portal provides a rich, pre-built monitoring experience that leverages Log Analytics Workspace (LAW) data under the hood. However, Microsoft does not directly expose or publish the exact Kusto Query Language (KQL) queries used in that built-in AVD Insights view. This is why, when you look in your connected Log Analytics Workspace, you won’t see a pre-defined workbook or set of saved queries matching what’s displayed in the Insights blade. The built-in view is generated dynamically by Azure Monitor using internal, managed queries tied to AVD metrics and diagnostic logs. To replicate this experience, you can manually access the underlying AVD diagnostic tables in your connected LAW—such as WVDConnections, WVDCheckpoints, WVDSessions, or WVDHostInformation (depending on your configuration)—and create custom Azure Workbooks or Power BI dashboards using KQL. Microsoft also provides a few sample queries and templates in the Azure Monitor Workbooks Gallery or the AVD GitHub repository that you can adapt. In summary, while the exact queries behind AVD Insights are not public, you can rebuild much of the functionality by exploring your LAW tables and crafting your own queries or importing available AVD workbook templates from GitHub to replicate the Insights experience within your environment.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"
Kind Regards,
Poojara - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
