Script to show performance

[Guv]

Is there a powershell script that I can run which show the VM's and their current cpu and memory performance. I have a script which can show the cpus and memory allocated, but i would like to find out if there any object properties I could use to get performance data.

[LucD]

You could use the Get-Stat cmdlet and ask for the Realtime statistics.

Have a look at for example

[Guv]

Thanks I can get the script working.

I have exported to a csv file and now have all the VM's listed with their host, cpu, memory. To make the csv file more presentable I want to list all VM's under their host, such as show all the VMs under their host , such as have their all Vm's in the same host listed together, or maybe have a heading for the host and then list all VM's and their performance. Can the above script be edited to show this, is this possible. Thanks

[LucD]

For the outut to a CSV file should each line look like this:

Host VM CPU Memory

Or did you have something else in mind ?

[Guv]

Yes something like this would be good, where the host is listed first and then all the VM's and its all fields are listed.

[LucD]

Try this one

Get-VM  | where {$_.PowerState -eq "PoweredOn"} |
	Select Host, Name, NumCpu, MemoryMB, 
		@{N="Cpu.UsageMhz.Average";E={[Math]::Round((($_ | Get-Stat -Stat cpu.usagemhz.average -Start (Get-Date).AddHours(-72) -IntervalMins 5 -MaxSamples (12) | Measure-Object Value -Average).Average),2)}}, 
		@{N="Mem.Usage.Average";E={[Math]::Round((($_ | Get-Stat -Stat mem.usage.average -Start (Get-Date).AddHours(-72) -IntervalMins 5 -MaxSamples (12) | Measure-Object Value -Average).Average),2)}} | `
	Export-Csv "C:\VM-stats.csv" -NoTypeInformation -UseCulture

Don't forget the back-tick on the 2nd to last line !

[Guv]

Thanks for the script.

If I wanted to display the csv file by displaying all the virtual machines in one host first, then the next host. Would you use the sort-object command

[LucD]

Yes, sort with -Properties Host, Name before creating the CSV file

[vAdmin]

Many thanks for the script Luc !

Kind Regards,

AWT