I'm tasked with figuring out the availability of virtual machines (VMs) for the months of July and August. While I can find the average, minimum, and maximum metrics, management wants a time series of events and the percentage availability for that entire month. Does anyone have suggestions on how I can achieve this?
2 Answers
You could use a Kusto query to pull the availability metrics, as long as you have the historical data for July and August. This should help you visualize the time series data you’re after.
I did a quick search online, and the first result from Microsoft Learn seemed solid. Maybe give that a shot? Sometimes those official docs have just what you need.
I usually try to avoid posting if I can't help out, but sometimes helping others can help clarify things for yourself too. Can't say how many resources I’ve scoured before asking for help, but it’s always good to explore first!
If you really want detailed metrics, you should definitely look into query capabilities for analytics tools. It’s frustrating when built-in metrics don't show what you really need.

Thanks for that! I have data from multiple Log Analytics Workspaces, so I’ll set up a query and see what I can pull together.