A simple Powershell script to monitor CUP/Mem utilization

#import powershell community extensions for increased functionality  
Import-Module Pscx   
 
#import vmware cli  
Add-PSSnapin "Vmware.VimAutomation.Core" -ErrorAction SilentlyContinue  
 
 
#vm vsphere server  
$vsphereServer = "10.xx.xx.xx"  
$vsphereUser = "administrator"  
$vspherePass = 'password'  
$Hostlist = get-content C:\Wayllen\Build-BVT\Utility-Scripts\vmHostName.txt   
 
#connect to the virtual server the VM's are on  
Connect-VIServer -Server $vsphereServer -Protocol https -User $vsphereUser -Password $vspherePass  
  
# Collect Host CPU/Memory utilization for one day.  
 $obj = @()  
 $count = 1  
 while($count -le 24){  
 $Hostlist | ForEach-Object { if ($_)  
                              {  
                                  $obj += `  
                                  get-vmhost  -Name $_ | sort | select Name,`  
                                  @{N="CPU Usage (%)";E={[math]::round(($_.CpuUsageMhz/$_.CpuTotalMhz)*100,2)}},`  
                                  @{N="Memory Usage (%)";E={[math]::round(($_.MemoryUsageMB/$_.MemoryTotalMB)*100,2)}},`  
                                  @{N="Date";E={(Get-Date).hour}}   
                              }   
                            }   
                            $count ++  
                            sleep -Seconds 3600  
  
}  
 
 
# Export CSV file.                                                
 $obj | Export-Csv C:\Wayllen\Build-BVT\Utility-Scripts\HostStatistics.csv -notype -ErrorAction SilentlyContinue