pshell.info

You can use the simple PowerShell script below to check ESX server patching status from your Windows client. Requirements:

• .NET Framework 2.0
• PowerShell v1.0
• plink.exe (from the Putty download page) in your path
• An account and password to remotely connect over SSH and execute the command esxupdate query.
• Change the $servers array with your servers and also update the $account and $password variable.
• Keep the $patches array up-to-date with ESX patch names.

The script:

$patches=”ESX-2158032″,”ESX-1410076″,”ESX-1006511″,”ESX-9986131″,”ESX-8173580″,”ESX-6921838″,”ESX-2066306″,”ESX-6075798″,”ESX-5497987″,”ESX-3996003″,”ESX-2092658″,”ESX-2031037″,”ESX-1917602″,”ESX-1271657″,”ESX-9865995″,”ESX-6856573″,”ESX-6050503″,”ESX-5885387″,”ESX-5031800″,”ESX-3199476″,”ESX-9916286″,”ESX-9617902″,”ESX-8852210″,”ESX-8174018″,”ESX-7780490″,”ESX-7737432″,”ESX-5011126″,”ESX-3416571″,”ESX-1161870″,”ESX-2559638″,”ESX-2257739″,”ESX-1541239″

$servers=”server0″,”server1″

$account=”root”
$password=”password”

$servers | % { $a=plink -pw $password $account@$_ “esxupdate query”

$server=$_

$patches | % {

  $patch=$_

  if( [regex]::match($a, $_).success ) {

     $summary=”Installed”
  }
  else
 {
    $summary=”Not installed”
 }

new-object psobject |
add-member -pass NoteProperty Server $server |
add-member -pass NoteProperty Patch $patch |
add-member -pass NoteProperty Summary $summary

}

}

 Save the above script as a .ps1 file (e.g. c:\patch.ps1) and run it as follows:

./patch.ps1 | ft -groupby server

You will get an overview of all patches grouped by server.