Get-DbaKbUpdate

Want to see the source code for this command? Check out Get-DbaKbUpdate on GitHub.
Want to see the Bill Of Health for this command? Check out Get-DbaKbUpdate.

Synopsis

Gets download links and detailed information for KB files (SPs/hotfixes/CUs, etc)

Description

Parses catalog.update.microsoft.com and grabs details for KB files (SPs/hotfixes/CUs, etc)

Because Microsoft's RSS feed does not work, the command has to parse a few webpages which can result in slowness.

Use the Simple parameter for simplified output and faster results.

Syntax

Get-DbaKbUpdate
    [-Name] <String[]>
    [-Simple]
    [[-Language] <String>]
    [-EnableException]
    [<CommonParameters>]

Examples

Example: 1

PS C:\> Get-DbaKbUpdate -Name KB4057119

Gets detailed information about KB4057119. This works for SQL Server or any other KB.

Example: 2

PS C:\> Get-DbaKbUpdate -Name KB4057119, 4057114

Gets detailed information about KB4057119 and KB4057114. This works for SQL Server or any other KB.

Example: 3

PS C:\> Get-DbaKbUpdate -Name KB4057119, 4057114 -Simple

A lil faster. Returns, at the very least: Title, Architecture, Language, Hotfix, UpdateId and Link

Example: 4

PS C:\> Get-DbaKbUpdate -Name KB4057119 -Language ja

Gets detailed information about KB4057119 in Japanese. This works for SQL Server or any other KB.
(Link property includes the links for Japanese version of SQL Server if the KB was Service Pack)

Example: 5

PS C:\> Get-DbaKbUpdate -Name KB4057119 -Language ja | Save-DbaKbUpdate

Downloads Japanese version of KB4057119.

Required Parameters

-Name

The KB name or number. For example, KB4057119 or 4057119.

Optional Parameters

-Simple

A lil faster. Returns, at the very least: Title, Architecture, Language, Hotfix, UpdateId and Link

-Language

Cumulative Updates come in one file for all languages, but Service Packs have a file for every language.
If you want to get only a specific language, use this parameter.
You you can press tab for auto-complete or use the two letter code that is used for Accept-Language HTTP header, e. g. "en" for English or "de" for German.

-EnableException

By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.
This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting.
Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch.