Availability and uptime report for Azure VMs

Question

Hi Team,

I require help in extracting availability and uptime reports for Azure VMs every 2 minutes using graphs and charts. Can you assist me in finding a solution for this?

The query below was run, but it only gave us Excel information, which isn't what we were seeking.

Heartbeat

// bin_at is used to set the time grain for 1 hour, starting exactly 24 hours ago

| Summarize heartbeatPerHour = count () by bin_at (TimeGenerated, 1h, ago (29d)), Computer

| Extend availablePerHour = if (heartbeatPerHour > 0, true, false)

| Summarize totalAvailableHours = countif (availablePerHour == true) by Computer

| Extend availabilityRate = totalAvailableHours * 100.0 / 696

FYI - We are using LA workspace and Microsoft monitoring agent.

Answer 1

Hello,

I'd look to take the KQL query you have an put it into an Azure Workbook (or Azure Dashboard). There are examples in Azure Monitor - look for the "Workbooks" blade, or start here:

https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-overview