Skip to main content

Get Latest Installed Cumulative Update

Summary​

The purpose of the script is to fetch the latest installed Cumulative Update and the Full Build Number of a Windows computer.
e.g.,
Image

The data is then stored in the custom table pvl_win_latest_installed_cu.

It is an Automate implementation of the agnostic script Get-LatestInstalledCU.

File Hash​

File Path: C:\ProgramData\_automation\Script\Get-LatestInstalledCU\Get-LatestInstalledCU.ps1
File Hash (Sha256): 4BC90F4D94F26CEC201A8EFE71C35289F998267A34E37CB5AECF40F0961061B5
File Hash (MD5): 71C2B794E53A957E48682B7D0DCF45F7
File Path: C:\ProgramData\_automation\Script\Get-LatestInstalledCU\Get-LatestInstalledCUAI.ps1
File Hash (Sha256): CA6C5B60BA4C3A6581486CC481F2A8F5C7EA96B67AA7D5DBC1B00F7997B59A80
File Hash (MD5): E041E20762DC1D52690FDED67E5768AD

Sample Run​

Image

Variables​

NameDescription
ProjectNameGet-LatestInstalledCU
WorkingDirectoryC:/ProgramData/_automation/script/Get-LatestInstalledCU
TableNamepvl_win_latest_installed_cu
SQLReplaceStatementREPLACE statement returned by the PowerShell script to update the data in the custom table
OSBuildFull OS Build of the computer
MaxReleaseDateMaximum CU release date stored in the database for @OSBuild@. Used to verify whether the computer's history has returned correct CU information or not.

Output​

  • Custom Table
  • Dataview