This script gives you the details about peak CPU, Memor, Disk, Network Stats, plus it includes date and time of the peak usage.
Check the section to define days back."#Define how long back you want to go and check the peak time and value",
Check the section to define days back."#Define how long back you want to go and check the peak time and value",
#####################################
## http://kunaludapi.blogspot.com
## Version: 1
## Tested this script on
## 1) Powershell v3
## 2) Powercli v5.5
## 3) Vsphere 5.x
#####################################
Add-PSSnapin vmware.vimautomation.core
# vCenter username password
$vCenterServer = "vCenterserver"
$vcenteruser = "domain\user"
$vcenterpasswd = "Password"
#connect vCenter Server
Connect-VIServer -Server $vCenterServer -User $vcenteruser -Password $vcenterpasswd
$Result = @()
$metrics = "cpu.usage.average", "mem.usage.average", "disk.usage.average", "net.usage.average"
$vms = Get-VMHost | Get-VM | Where-Object {$_.PowerState -eq “PoweredOn”}
#Define how long back you want to go and check the peak time and value.
$start = (Get-Date).AddDays(-7)
$finish = (Get-Date).AddDays(-6)
Foreach ($vm in $vms) {
$AllStats = Get-Stat -Entity $vm -Stat $metrics -MaxSamples ([int]::MaxValue) -Start $start -Finish $finish -IntervalMins 5
#vCPU calculations
$CPUStats = $AllStats | Where-Object {$_.Metricid -eq "cpu.usage.average"} | Measure-Object -Property Value -Maximum | Select -ExpandProperty Maximum
$RoundCPUStats = [math]::Round($CPUStats)
$CPUStatsDate = $AllStats | Where-Object {$_.Metricid -eq "cpu.usage.average" -and $_.value -eq $CPUStats} | Select-Object -ExpandProperty Timestamp
#Memory calculations
$MemStats = $AllStats | Where-Object {$_.Metricid -eq "mem.usage.average"} | Measure-Object -Property Value -Maximum | Select -ExpandProperty Maximum
$RoundMemStats = [math]::Round($MemStats)
$MemStatsDate = $AllStats | Where-Object {$_.Metricid -eq "mem.usage.average" -and $_.value -eq $MemStats} | Select-Object -ExpandProperty Timestamp
#Disk calculations
$DiskStats = $AllStats | Where-Object {$_.Metricid -eq "disk.usage.average"} | Measure-Object -Property Value -Maximum | Select -ExpandProperty Maximum
$RoundDiskStats = [math]::Round($DiskStats)
$DiskStatsDate = $AllStats | Where-Object {$_.Metricid -eq "disk.usage.average" -and $_.value -eq $DiskStats} | Select-Object -ExpandProperty Timestamp
#Network calculations
$NetStats = $AllStats | Where-Object {$_.Metricid -eq "net.usage.average"} | Measure-Object -Property Value -Maximum | Select -ExpandProperty Maximum
$RoundNetStats = [math]::Round($NetStats)
$NetStatsDate = $AllStats | Where-Object {$_.Metricid -eq "net.usage.average" -and $_.value -eq $NetStats} | Select-Object -ExpandProperty Timestamp
$Obj = New-Object PSObject
$Obj | Add-Member -MemberType NoteProperty -Name "VMName" -Value $vm.Name
$Obj | Add-Member -MemberType NoteProperty -Name "Date_MaxUsage_vCPU" -Value $CPUStatsDate[0]
$Obj | Add-Member -MemberType NoteProperty -Name "vCPU_Usage_Max(%)" -Value $RoundCPUStats[0]
$Obj | Add-Member -MemberType NoteProperty -Name "Date_MaxUsage_Mem" -Value $MemStatsDate[0]
$Obj | Add-Member -MemberType NoteProperty -Name "Mem_Usage_Max(%)" -Value $RoundMemStats[0]
$Obj | Add-Member -MemberType NoteProperty -Name "Date_MaxUsage_Disk" -Value $DiskStatsDate[0]
$Obj | Add-Member -MemberType NoteProperty -Name "Disk_Usage_Max(KBps)" -Value $RoundDiskStats[0]
$Obj | Add-Member -MemberType NoteProperty -Name "Date_MaxUsage_Net" -Value $NetStatsDate[0]
$Obj | Add-Member -MemberType NoteProperty -Name "Net_Usage_Max(KBps)" -Value $RoundNetStats[0]
$result += $Obj
}
$result | Export-Csv -NoTypeInformation -Path C:\temp\Stats.csv
