Apologies, and thanks for these info, LucD. I am not aware that we have some guidelines when posting to this group.
Below is the script that I am using to collect the CPU and Memory usage (credits to the owner on this forum). As mentioned I am not a scripting guys, therefore I am trying my best to achieve my requirements based on the others script on this forum.
I've been trying to look for a reference regarding how to upload and automatically dump the output of the script to a Linux machine via WinSCP but to no luck. Hope someone can enlighten me regarding this.
Thanks again in advance.
$vms = Get-Content D:\Test\Test.txt
$start = (Get-Date).AddMinutes(-1)
Get-Stat -Entity $vms -Start $start -ErrorAction SilentlyContinue |
Group-Object -Property {$_.Entity.Name} |
Select @{N='VM';E={$_.Name}},
@{N='CPU(%)';E={"{0:N1}" -f ($_.Group | where{$_.MetricID -eq 'cpu.usage.average'} | Measure-Object -Property Value -Average | select -ExpandProperty Average)}},
@{N='Memory(%)';E={"{0:N1}" -f ($_.Group | where{$_.MetricID -eq 'mem.usage.average'} | Measure-Object -Property Value -Average | select -ExpandProperty Average)}} |
Export-CSV D:\Test\Test.csv -NoTypeInformation -UseCulture
