Trying to create dashbord containing high uptime servers

Anonymous
2022-03-07T07:51:08.99+00:00

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?

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,867 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,285 questions
0 comments No comments
{count} votes

Accepted answer
  1. vipullag-MSFT 25,041 Reputation points
    2022-03-09T09:46:39.337+00:00

    @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.

    2 people found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Andrew Blumhardt 9,586 Reputation points Microsoft Employee
    2022-03-29T13:07:15.153+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments