Getting average CPU and Memory usage for all azure VMs in a resource group

Question

Getting average CPU and Memory usage for all azure VMs in a resource group

Anonymous

Hello,

I am trying to get average cpu & memory utilization for VMs in a resource group via script so I can export the required details to a CSV file. I have a mix of linux & windows VMs within this RG. Tried a PS script with get-wmiobject module with a checkpoint condition ( with test-path) but this seems to give me the null output even for the windows vm . Are there azure cli/ powershell commands that can give this? Explored azuremetrics module but looks like this does not provide average memory utilization. Any pointers towards the right direction would be much appreciated.

I tried the PS script provided at https://www.powershellbros.com/run-script-to-check-cpu-and-memory-utilization/

Thanks & Regards
Suneel

1 answer

Your answer

Answer 1

srbhatta-MSFT 8,586 Microsoft Employee

Hi @Anonymous ,
The script link that you have posted is a custom Powershell script so you have to tweak that according to your requirements.
Also, are you looking to specifically export the required details to a csv automatically?
If not, then you can also check these metrics from the Portal-> under your VM -> Monitoring.

Anonymous

2022-11-23T11:17:33.73+00:00

Thanks for the response @srbhatta-MSFT

I am specifically looking to import them to a csv. I tried to tweak them. When I try this from within my local machine Get-wmiobject / Get-CimInstance I get below error:
Message : The WinRM client cannot process the request. If the authentication scheme is different from Kerberos, or if the client computer is not joined to a domain, then HTTPS transport must be used or the destination machine must be added to the TrustedHosts configuration setting. Use winrm.cmd to configure TrustedHosts. Note that computers in the TrustedHosts list might not be authenticated. You can get more information about that by running the following command: winrm help config.

The actual command to get the metrics when i run using the "run" option on the VM within portal gives me the expected output. Looks like remote execution keeps failing. Did some google but could not find a proper way to get this fixed.

Regards
Suneel
srbhatta-MSFT 8,586 Reputation points Microsoft Employee

2022-11-28T15:18:24.157+00:00

Hi @Anonymous ,
Apologies for the delay in response. I understand the issue now. So, is your VM domain joined? If not, have you added the destination machine to the trusted hosts config file as per the verbose error. Definitely some network level issue that we can figure out soon. I will wait for your response. :)
Anonymous

2022-11-30T06:59:55.61+00:00

Thanks for the reply @srbhatta-MSFT . I had this on my own subscription so there is no AD to join. But this looks like firewall restrictions to allow remote command execution. This task is currently shelved. But I will keep you posted if I get to solve this.

Regards
Suneel
srbhatta-MSFT 8,586 Reputation points Microsoft Employee

2022-11-30T07:08:09.09+00:00

Sure, thanks.

Share via

Getting average CPU and Memory usage for all azure VMs in a resource group

1 answer

Your answer