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): B2AB1980397783AB0FAD045361229F75AF86DD0FEE2D56E2D11C057CDC7F9264
File Hash (MD5): F785240ACE2516427D6A80C8DFD5FD62

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