Automate daily checks for Azure VMs

Yu-Jeong Seo 110

Hello, I would like to check the CPU percentage, Disk IOPS, and Memory availability values of Azure VMs daily in an Excel file.

I am considering using Azure Automation for this. Is there a script that I can refer to for automating the process of retrieving these values for multiple VMs every morning, creating an Excel file, and uploading it to Blob Storage?

Alternatively, I would appreciate any recommendations for affordable Azure resources that can help me check these values daily.

Domooney-MSFT 2,596 Reputation points Microsoft Employee

2024-10-31T13:21:05.9333333+00:00

Hi Yu-Jeong Seo

Thank you for posting your query on Microsoft Q&A!

We do have the Get-AzMetric Powershell command which is part of the Azure monitor module, it should be possible to get the data your looking for using this command, then we just need to loop through your list of VMs. - https://learn.microsoft.com/en-us/powershell/module/az.monitor/get-azmetric?view=azps-12.3.0

I will reach out to our Azure Monitoring team to help with this and get back to you ASAP.

Kind Regards,

Donal
Ryan Hill 28,716 Reputation points Microsoft Employee

2024-10-31T15:46:10.3366667+00:00

Hello @Yu-Jeong Seo

Is there any reason for avoiding Azure Monitor through Log Analytics to track VM metrics?
Yu-Jeong Seo 110 Reputation points

2024-11-01T00:19:49.2866667+00:00

Hello, @Ryan Hill

I would like to use Azure without install Log Analytics gents on the operating system, as I want to check daily reports in an Excel file. For processing the Excel files, I believe Azure Automation would be the most suitable option.

However, if it is possible to automate the daily retrieval of well-organized Azure VM metrics using Log Analytics, I am also open to using Log Analytics.
Yu-Jeong Seo 110 Reputation points

2024-11-01T00:23:02.3966667+00:00

Hello, @Ryan Hill

I would like to use Azure without install agents on the operating system, as I want to check daily reports in an Excel file. For processing the Excel files, I believe Azure Automation would be the most suitable option. However, if it is possible to automate the daily retrieval of well-organized Azure VM metrics using Log Analytics, I am also open to using Log Analytics.
Yu-Jeong Seo 110 Reputation points

2024-11-01T00:31:03.61+00:00

Hello, @Domooney-MSFT

It seems that the values retrieved using Get-AzMetric do not appear to be available by time intervals.

I need an automation script that checks the metrics at 5-minute intervals and records those values in an Excel file. Could you please help with this?
KarishmaTiwari-MSFT 20,212 Reputation points Microsoft Employee

2024-11-04T22:38:55.9966667+00:00

@Yu-Jeong Seo Did the comment above help? Please let us know the update and we can help further.
Yu-Jeong Seo 110 Reputation points

2024-11-05T00:06:55.6766667+00:00

KarishmaTiwari-MSFT Thank you! it was helpful.

Accepted answer

Ryan Hill 28,716 Reputation points Microsoft Employee

2024-11-02T03:39:25.39+00:00

Hello @Yu-Jeong Seo

Following the Chart performance with VM insights - Azure Monitor | Microsoft Learn guide would certainly be easier. It charts everything for you, but you do have to pay for the Log Analytics storage. Even that's something you really want to avoid; I think getting by with Get-AzMetric is certainly doable. To get 5-minute intervals, use PT5M for -TimeGrain.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Automate daily checks for Azure VMs

0 additional answers

Your answer