VMware PowerCLI – Get Cluster host status script

Made a small script to keep up with the hosts in a cluster, to get a daily report of their usage, Virtual machine count, and other overview information. This script can be scheduled with Task scheduler if you want.

##############################################################
###
### VMHost status query script
### Version 0.2
### 21.1.2013
###
##############################################################
###
### CONFIGURATION
###
###
$export_path = "C:\Datacenter\ESXi_Host_Status"
$export_datef = get-date -format yyyy-MM-dd-H-mm
$login_user = ""
$login_pwd = ""
$login_hosts = " INSERT YOUR vCenter Server here"
##############################################################
### END
##############################################################
###Prepare variables
$end = get-date
###Check if we are connected to vCenter Server(s)
if($global:DefaultVIServers.Count -lt 1)
{
 Connect-VIServer $login_hosts -User $login_user -Password $login_pwd -AllLinked:$true
}
else
{
 echo "Already connected"
}
###Query all VMHosts
$result = Get-VMHost | select name,`
@{N="CpuUsageMhz"; E={[Math]::Round($_.CpuUsageMhz, 3)}}, @{N="CpuTotalMhz"; E={[Math]::Round($_.CpuTotalMhz, 3)}},`
@{N="CpuUsage%"; E={"{0:P0}" -f [Math]::Round($_.CpuUsageMhz/$_.CpuTotalMhz, 3)}},`
@{N="MemoryUsageGB"; E={[Math]::Round($_.MemoryUsageGB, 3)}}, @{N="MemoryTotalGB"; E={[Math]::Round($_.MemoryTotalGB, 3)}},`
@{N="MemoryUsage%"; E={"{0:P0}" -f [Math]::Round($_.MemoryUsageGB/$_.MemoryTotalGB, 3)}},`
@{N="VM Count"; E={$_.ExtensionData.vm.count}},`
@{N="Uptime"; E={(new-timespan $_.ExtensionData.Summary.Runtime.BootTime $end).days}},`
@{N="Overall Status"; E={$_.ExtensionData.OverallStatus}}, `
@{N="Configuration Status"; E={$_.ExtensionData.ConfigStatus}}`
| sort name
###Print out the result
$result | format-table -autosize | out-default
###Export the result to a CSV file
$result | export-csv -path "$export_path\ESXi-Host-Status-$export_datef.csv" -useculture