I was definitely not trying to make fun of you, just of the type of question.
We sometimes get some very 'general' questions in here, not specifying any details, which are in fact nothing more than a "do my work for me" kind of request.
Now with your last reply, you asked a practical question.
That is something we can try to help you with.
Some things to check/answer:
- how did you run the script? From a PS prompt? From a .ps1 file?
- are you connected to a vCenter before running the script? Or an ESXi node?
- the attached file contains some funny characters, but that might be due to a regional setting on your station. In any case, I start from the edited version below.
- do you keep statistical data for at least 30 days in your vCenter? On an ESXi node you don't have historical statistical data.
- in the Web Client, under the Performance tab, do you see data for the VMs when you select a 30 day period?
$metrics = "cpu.usage.average", "mem.usage.average", "disk.usage.average"$start = (Get-Date).AddDays(-30)
$folders = Get-Folder -Location (Get-Folder -Name vm -Location Datacenters)
# $folders = Get-Folder -Name Folder1,Folder2,Folder3
& { foreach ($folder in $folders)
{
$vms = Get-VM -Location $folder
if ($vms)
{
$stats = Get-Stat -Entity $vms -Stat $metrics -Start $start -ErrorAction SilentlyContinue
if ($stats)
{
$stats | Group-Object -Property { $_.Entity.Name } | % {
New-Object PSObject -Property @{
Folder = $folder.Name
VM = $_.Values[0]
CpuAvg = ($_.Group | where { $_.MetricId -eq "cpu.usage.average" } | Measure-Object -Property Value -Average).Average
MemAvg = ($_.Group | where { $_.MetricId -eq "mem.usage.average" } | Measure-Object -Property Value -Average).Average
DiskAvg = ($_.Group | where { $_.MetricId -eq "disk.usage.average" } | Measure-Object -Property Value -Average).Average
}
}
}
}
} } | Export-Csv C:\report.csv -NoTypeInformation -UseCulture
