Using Save-DbaKbUpdate to download SQL Server Cumulative Updates

[andreasjordan]

For my lab environment, I sometimes need some of the last cumulative updates to play around with.

To get them all at once, I build a small wrapper function.
If you have similar needs - then this might help you in building your own function.

Import-Module -Name dbatools -MinimumVersion 1.0.173

function Get-CU {
    param(
        [Parameter(Mandatory)]
        [ValidateSet('2019', '2017', '2016', '2014')]
        [string]$Version,
        [regex]$BuildBaseRegex,
        [int]$Last = 999,
        [string[]]$Exclude,
        [string]$Path = '.'
    )
    if ($null -eq $BuildBaseRegex) {
        $BuildBaseRegex = switch ($Version) {
            '2019' { '^15' }
            '2017' { '^14' }
            '2016' { '^13.0.5' }  # Based on SP2
            '2014' { '^12.0.6' }  # Based on SP3
        }
    }
    if ($Version -eq '2019') { 
        $Exclude += 'CU7'  # CU7 is not available any more
    }
    $buildrefFile = Join-Path -Path (Get-DbatoolsConfigValue -Name 'Path.DbatoolsData') -ChildPath "dbatools-buildref-index.json"
    $buildrefData = (Get-Content -Path $buildrefFile -Raw | ConvertFrom-Json).Data
    $cuData = $buildrefData | 
        Where-Object -FilterScript { $_.Version -match $BuildBaseRegex -and $_.CU -ne $null -and $_.CU -notin $Exclude } |
        Sort-Object -Property KBList |
        Select-Object -Last $Last
    foreach ($cu in $cuData) {
        $kbNr = $cu.KBList
        $cuName = $cu.CU
        $filePath = Join-Path -Path $Path -ChildPath "SQLServer$Version-KB$kbNr-$cuName-x64.exe"
        if (-not (Test-Path -Path $filePath)) {
            Save-DbaKbUpdate -Name $kbNr -FilePath $filePath
        }
    }
}

Update-DbaBuildReference
$patchPath = 'C:\SQLServerPatches'
Get-CU -Version 2019 -Path $patchPath
Get-CU -Version 2017 -Path $patchPath -Last 5
Get-CU -Version 2016 -Path $patchPath -Last 5
Get-CU -Version 2014 -Path $patchPath
# KB4583462 - Security update for SQL Server 2014 SP3 CU4: January 12, 2021
Save-DbaKbUpdate -Name 4583462 -FilePath "$patchPath\SQLServer2014-KB4583462-CU4-Security-x64.exe"
# KB4583465 - Security update for SQL Server 2012 SP4 GDR: January 12, 2021
Save-DbaKbUpdate -Name 4583465 -FilePath "$patchPath\SQLServer2012-KB4583465-GDR-Security-x64.exe"

[andreasjordan]

You can find an updated version here: https://github.com/andreasjordan/demos/blob/master/dbatools/Get-CU.ps1