hi - i have a script that details stats for previous 24 hours. I am trying to amend so that it displays the vSwitch name the VMNIC is attached to (ie vSwitch0, vSwitch1 etc etc). I have been trying to get the information to show but i either get a blank column, or i get all the vswitches listed in each row. Any advice ? Thanks in advance
$date = get-date
$vccred = import-pscredential -Path xxxxxx
connect-VIServer -Server xxxxxx -Credential $vccred
$metrics = "net.received.average","net.transmitted.average"
$todayMidnight = Get-Date -Hour 0 -Minute 0 -Second 0
$start = $todayMidnight.AddDays(-1).AddSeconds(1)
$finish = $todayMidnight
foreach ($cluster in Get-cluster | sort-object Name)
{
ConvertTo-Html –body "
$cluster
" | Out-File -append $htmlNICstats
$clusterTmp = @()
write-host " > " $cluster
foreach ($esxImpl in (get-vmhost -Location $cluster | Sort-Object Name))
{
write-host " > " $esxImpl
$ESXHostTMP = @()
$esx = $esxImpl | Get-View
foreach ($vmhost in $esx){
$stats = Get-Stat -Entity $esximpl -Stat $metrics -Start $start -Finish $finish
$stats | Group-Object -Property Instance | where {$_.Name -ne ""} | %{
$row = "" | Select clustername , vswitch , "ESX Name", Date , NIC ,"Max Send MBps","Max Received MBps"
$row.clustername = $cluster.name
$row.vswitch =
$row."ESX Name" = $_.Group[0].Entity.Name
$row.Date = $start.ToShortDateString()
$row.NIC = $_.Group[0].Instance
$row."Max Send MBps" = "{0:f2}" -f (($_.Group | where {$_.MetricId -eq "net.transmitted.average"} | Measure-Object -Property Value -Maximum).Maximum/1KB)
$row."Max Received MBps" = "" -f (($_.Group | where {$_.MetricId -eq "net.received.average"} | Measure-Object -Property Value -Maximum).Maximum/1KB)
$ESXHostTMP += $row
$Report = $Report + $row
}
}
$ESXHostTMP | sort-object Nic | ConvertTo-Html -property clustername , vswitch , "ESX Name" , Date , NIC , "Max Send MBps","Max Received MBps" | Out-File -append $htmlNICStats
}
