Sample Preventive Maintenance Reports with PowerCLI

Refer to the list of Sample Preventive Maintenance Reports with PowerCLI

  1. Connect to vCenter with PowerCLI
#Import VMware Module
Import-Module VMware.VimAutomation.Core

$vCenter = "10.253.24.16"
$User = "administrator@vsphere.local"
$Password = "P@ssw0rd"

Connect-VIServer -Server $vCenter -User $User -Password $Password -WarningAction SilentlyContinue
  1. To get hardware inventory for all VMware ESXi host
$VMHosts = Get-VMHost
Foreach ($VMHost in $VMHosts) { 

Get-VMHost -Name $VMHost | Select Name, 
Model, 
@{N="S/N" ; E={(Get-VMHostHardware -VMHost $VMHost).SerialNumber}},
ProcessorType, 
@{N="No of CPU" ; E={(Get-VMHostHardware -VMHost $VMHost).CpuCount}},
NumCPU,
@{N="Total RAM" ; E={[math]::Round((Get-VMHost -name $VMHost).MemoryTotalGB,0)}},
@{N="Network Cards" ; E={(Get-VMHostHardware -VMHost $VMHost).NICCount}},
@{N="FC HBA" ; E={(Get-VMHostHBA -VMHost $VMHost | ? Type -EQ "FibreChannel").count}},
Version, 
Build,
@{N="Up Time (Days)" ; E= {New-Timespan -Start (Get-VMHost -Name $VMHost).ExtensionData.Summary.Runtime.BootTime -End (Get-Date) | Select -ExpandProperty Days}} | Export-Csv -Path C:\Temp\VMHostInventory.csv -NoTypeInformation -Append } 


PowerCLI-PM-02

  1. To get the average resource utilization for Processor, RAM, Storage and Network for past 30 days with 24 hours interval for VMware Hosts
$VMHosts = Get-VMHost
Foreach ($VMHost in $VMHosts) { 

Get-VMHost -Name $VMHost | Select Name, `
@{N="Up Time (Days)" ; E= {New-Timespan -Start (Get-VMHost -Name $VMHost).ExtensionData.Summary.Runtime.BootTime -End (Get-Date) | Select -ExpandProperty Days}}, `
CPUTotalMhz, `
@{N="CPU Usage (Average), Mhz" ; E={[Math]::Round((($_ | Get-Stat -Stat cpu.usagemhz.average -Start (Get-Date).AddDays(-30) -IntervalSecs 86400 | Measure-Object Value -Average).Average),2)}}, `
@{N="Memory Total (GB)";E={[math]::Round($_.MemoryTotalGB)}}, `
@{N="Memory Usage (Average)" ; E={[Math]::Round((($_ | Get-Stat -Stat mem.usage.average -Start (Get-Date).AddDays(-30) -IntervalSecs 86400 | Measure-Object Value -Average).Average),2)}}, `
@{N="Network Usage (Average), KBps" ; E={[Math]::Round((($_ | Get-Stat -Stat net.usage.average -Start (Get-Date).AddDays(-30) -IntervalSecs 86400 | Measure-Object Value -Average).Average),2)}},`
@{N="Disk Usage (Average), KBps" ; E={[Math]::Round((($_ | Get-Stat -Stat disk.usage.average -Start (Get-Date).AddDays(-30) -IntervalSecs 86400 | Measure-Object Value -Average).Average),2)}} `
| Export-Csv C:\Temp\Usage.csv -NoTypeInformation -Append }


PowerCLI-PM-01

  1. Get the Usage of Datastore
Get-Datastore | ? Type -like "VMFS" | Select Name, 
@{N="Capacity(GB)" ; E={[math]::Round(($_.CapacityGB),2)}},
@{N="Free(GB)" ; E={[math]::Round(($_.FreeSpaceGB),2)}},
@{N="Usage %" ; E={[math]::Round((1-($_.FreeSpaceGB/$_.CapacityGB))*100)}},
@{N="No of VM";E={@($_ | Get-VM).Count}} | Export-Csv C:\Temp\DataStore.csv -NoTypeInformation


PowerCLI-PM-03

  1. To get the average resource utilization for Processor, RAM, Storage and Network for past 30 days with 24 hours interval for Virtual Machines (VMs)
Get-VM | Where {$_.PowerState -eq "PoweredOn"} | Select Name, VMHost, NumCpu, MemoryMB,  `
@{N="CPU Usage (Average), Mhz" ; E={[Math]::Round((($_ | Get-Stat -Stat cpu.usagemhz.average -Start (Get-Date).AddDays(-30) -IntervalSecs 86400 | Measure-Object Value -Average).Average),2)}}, `
@{N="Memory Usage (Average), %" ; E={[Math]::Round((($_ | Get-Stat -Stat mem.usage.average -Start (Get-Date).AddDays(-30) -IntervalSecs 86400 | Measure-Object Value -Average).Average),2)}} , `
@{N="Network Usage (Average), KBps" ; E={[Math]::Round((($_ | Get-Stat -Stat net.usage.average -Start (Get-Date).AddDays(-30) -IntervalSecs 86400 | Measure-Object Value -Average).Average),2)}} , `
@{N="Disk Usage (Average), KBps" ; E={[Math]::Round((($_ | Get-Stat -Stat disk.usage.average -Start (Get-Date).AddDays(-30) -IntervalSecs 86400 | Measure-Object Value -Average).Average),2)}},
@{N="OS Installed" ; E={(Get-VMGuest -VM $_.name).OSFullName}} |
Export-Csv -Path C:\Temp\VM.csv -NoTypeInformation -Append


PowerCLI-PM-04

  1. List the usage of individual volumes / partitions for all VM
foreach ($VM in Get-VM) { 

   $vDisks = (Get-VM -name $VM).Guest.Disks 

   foreach ($vDisk in $vDisks) { 

    $VM | Select Name,
        @{N="Capacity" ; E={[math]::Round(($vDisk.CapacityGB),2)}},
        @{N="Free Space" ; E={[math]::Round(($vDisk.FreeSpaceGB),2)}},
        @{N="Usage %" ; E={[math]::Round((1-($vDisk.FreeSpaceGB/$vDisk.CapacityGB))*100)}},
        @{N="Path" ; E={($vDisk.Path)}} | Export-Csv -Path C:\Temp\VMDiskUsage.csv -NoTypeInformation -Append
    }
}


PowerCLI-PM-05

  1. List VM with ISO file attached
##### List VM with ISO File Attached
Get-VM | ? { $_ | Get-CDDrive| ? { $_.ConnectionState.Connected -eq "true" -and $_.ISOPath -like "*.ISO*"} }  | 
Select Name, @{Name=".ISO Path";Expression={(Get-CDDrive $_).isopath }} | Export-Csv C:\Temp\ISOAttached.csv -NoTypeInformation


PowerCLI-PM-06

  1. List VM with active snapshot created
Get-VM | Get-Snapshot | Select Created, VM, Description,@{Name="Size (GB)";Expression={[math]::Round($_.SizeGB ,2)}} | Sort Created | export-csv C:\Temp\snapshot.csv -NoTypeInformation 


PowerCLI-PM-07

  1. List VM with exceed 90% of Disk Usage
foreach ($VM in Get-VM) { 

   $vDisks = (Get-VM -name $VM).Guest.Disks 

   foreach ($vDisk in $vDisks) { 

    $VM | Select Name,
        @{N="Capacity" ; E={[math]::Round(($vDisk.CapacityGB),2)}},
        @{N="Free Space" ; E={[math]::Round(($vDisk.FreeSpaceGB),2)}},
        @{N="Usage %" ; E={[math]::Round((1-($vDisk.FreeSpaceGB/$vDisk.CapacityGB))*100)}},  
        @{N="Path" ; E={($vDisk.Path)}} | ? "Usage %" -gt "90" | Export-Csv C:\Temp\VMwith90%DiskUsage.csv -NoTypeInformation -Append
    }
} 


PowerCLI-PM-08

  1. List VMs which are running on outdated VMtool
Foreach ($VM in (Get-VM)) { 

    $VM | Select Name, 
    @{N="VMtools" ; E={(Get-View $_.id).config.tools.ToolsVersion}},
    @{N="Status" ; E={(Get-View $_.id).guest.ToolsVersionStatus}},
    @{N="OS" ; E={($_ | Get-VMGuest).OSFullName}} | ? "Status" -NotLike "guestToolsCurrent" | 
    Export-Csv -Path C:\Temp\VMtool.csv -NoTypeInformation -Append

}

VMtools=2147483647 is refering to the open-vm-tools


PowerCLI-PM-09

  1. List of Zombie VMDK files

#Initial Array $Report = @() $AllVMDK =@() $ZombieVMDK = @() #Get all Datastore for VMFS Usage $DSs = Get-Datastore | ? Type -like "VMFS" $SearchSpec = New-Object VMware.Vim.HostDatastoreBrowserSearchSpec foreach ($DS in $DSs) { $DSBrowser = Get-View -Id $DS.ExtensionData.browser $RootPath = "[" + $DS.Name + "]" $SearchResult = $DSBrowser.SearchDatastoreSubFolders($RootPath, $SearchSpec) | Sort-Object -Property {$_.FolderPath.Length} foreach ($folder in $SearchResult) { #list only file with .vmdk foreach ($file in ($folder.file | ? {$_.path -like "*.vmdk" -and $_.path -notlike "*-flat.vmdk" -and $_.path -notlike "*-ctk.vmdk" })) { #New object to store all VMDK files $PSObject = New-Object PSObject -Property @{ folder = $folder.FolderPath File = $file.path } $Report += $PSObject } } } #Join the Full File name foreach ($item in $Report) { $list_VMDK = $item.folder + $item.file $AllVMDK += @($list_VMDK) } #List all the Active VMDK file used by vCenter foreach ($VM in (Get-VM)) { $VMDKFiles = (($VM | Get-HardDisk).Filename) foreach ($VMDKFile in $VMDKFiles) { $ActiveVMDK += $VMDKFile } } #Search all the Active VMDK files to find the Zombie File Foreach ($VMDK in $AllVMDK) { if ($VMDK -notin $ActiveVMDK) { #New object to store all VMDK files $PSObject = New-Object PSObject -Property @{ Path = $VMDK.ToString() Description = "Possibly a Zombie vmdk file!" } $ZombieVMDK += $PSObject } } #EXport the Zombie VMDK File to CSV file $ZombieVMDK | Select Path, Description | Export-Csv -Path C:\Temp\ZombiVM.csv -NoTypeInformation


PowerCLI-PM-10

Leave a Comment