Trying to create dashbord containing high uptime servers

Question

I'm trying to get an overview of vm's in azure with high uptime, preferable something that can be sorted descending with highest uptime on top.
Can't seem to find any good query/workbook for this, got any tips?

Answer 1

@Anonymous

Welcome to Microsoft Q&A Platform, thanks for posting your query here.

I see a support case opened for the same. I am summarizing the details provided by support team here for the benefit of community, so that it can help others in the community looking for help on similar topics.

Requirement: Looking for a solution to monitor the VM's based on uptime via a dashboard.

The current capabilities of Azure Monitor VM insights does not have this as a out of box solution.

So it is suggested to use Azure Monitor Workbooks to build your custom dashboards. Reference article (https://github.com/azure-ad-b2c/siem).

To mention, Workbooks provide a flexible canvas for data analysis and the creation of rich visual reports within the Azure portal. More details can be found in below docs:
https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-overview
https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-grid-visualizations.
You can also check the video tutorials available here.

Workbook can use KQL queries that transform the underlying resource data to select a result set that can visualized as text, charts, or grids. For building a query to calculate the uptime, you may leverage the queries mentioned in the link here.

Please 'Accept as answer', so that it can help others in the community looking for help on similar topics.

Answer 2

The Windows OS has a System>System Up Time counter. The metric is not collected by default. You first need to collect the counter using a diagnostic or log analysis collection. Creating the dashboard or workbook from there should be fairly simple.