Hi All
Am using below script to capture CPU and Mem report for Last 2 weeks since last month there was no issues and am getting the report correctly but now am not getting the CPU value correctly
Only change what i have done is Updated the host from ESXi 5.5 U2 to Esxi 5.5 U3d
# VCenter Server Details
$server_address = "Vcenter1"
add-pssnapin vmware.vimautomation.core
Connect-VIserver -server $server_address
Write-host "Gathering Avg CPU & MEM utilization of ESX hosts for last 2 weeks"
$d = get-date -DisplayHint DateTime -Format "d-MMM-yy"
$host1 = Get-vmhost | sort
$utilization = @()
$todayMidnight = (Get-Date -Hour 0 -Minute 0 -Second 0).AddMinutes(-1)
$workingDays = "Monday","Tuesday","Wednesday","Thursday","Friday"
$dayStart = New-Object DateTime(10,04,17,0,00,0) # 00:00 AM
$dayEnd = New-Object DateTime(23,04,17,23,59,0) # 12:50 PM
Foreach ( $h in $host1)
{
$ESXhost = $h.name
# Calculate the Average CPU Usage of each ESX host
$A = Get-Stat -entity $h.name -stat cpu.usage.average -start (get-Date).adddays(-15) -finish (get-date).adddays(-1)
$report = $A | Where-Object {
$workingDays -contains $_.Timestamp.DayOfWeek -and
$_.Timestamp.TimeOfDay -ge $dayStart.TimeOfDay -and
$_.Timestamp.TimeOfDay -le $dayEnd.TimeOfDay }
$CPU1 = $report | Measure-Object -property value -average
$CPU1 = $CPU1.Average
# Calculate the Average MEM Usage of each ESX host
$B = Get-Stat -entity $h.name -stat mem.usage.average -start (get-Date).adddays(-15) -finish (get-date).adddays(-1)
$report1 = $B | Where-Object {
$workingDays -contains $_.Timestamp.DayOfWeek -and
$_.Timestamp.TimeOfDay -ge $dayStart.TimeOfDay -and
$_.Timestamp.TimeOfDay -le $dayEnd.TimeOfDay }
$MEM1 = $report1 | Measure-Object -property value -average
$MEM1 = $MEM1.Average
# Create a new object for output
$objHostInfo = New-Object System.Object
$objHostInfo | Add-Member -MemberType NoteProperty -Name AvgCPU -Value $CPU1
$objHostInfo | Add-Member -MemberType NoteProperty -Name AvgMEM -Value $MEM1
$objHostInfo | Add-Member -MemberType NoteProperty -Name HostIP -Value $ESXhost
$utilization += $objHostInfo
}
$utilization | Export-csv C:\Report-$d.csv
