Get-SqlServerBuild.ps1

<#
  Work in progress
  
  Pull build versions into PSObjects from the super-useful https://sqlserverbuilds.blogspot.co.uk
#>

#$Blog = Invoke-WebRequest https://sqlserverbuilds.blogspot.co.uk/

$TablesHtml = [regex]::Matches(
    $Blog.RawContent,
    (
        '<table .+?>\n' +
        '<tr><th>Build<th class=h>SQLSERVR.EXE Build<th>File version<th class=h>Q<th class=h>KB<th width=580>KB / Description<th width=125>Release Date</tr>' +
        '.+?' +
        '</table>'
    ),
    [System.Text.RegularExpressions.RegexOptions]::Singleline
) | select -ExpandProperty Value


$Tables = @()

foreach ($TableHtml in $TablesHtml) {

    $Rows = [regex]::Matches(
        $TableHtml,
        '<tr>.+?</tr>'

    ) | select -ExpandProperty Value

    $HeaderRow = $Rows[0]
    $Rows = $Rows | select -Skip 1

    $Headers = [regex]::Matches(
        $HeaderRows,
        '(?<=<th.*?>).+?(?=<)'
    ) | foreach {
        $_.Value
    }

    #$Output = @()

    foreach ($Row in $Rows[1..11]) {
        $Properties = `
        [regex]::Matches(
            $Row,
            '(?<=<td.*?>).+?(?=<)'
        ) | foreach {
            $_.Value -replace '^(<td.*?>)'
        }

        $Obj = New-Object psobject -Property @{
            Build = $Properties[0];
            FileVersion = $Properties[1];
            Q = $Properties[2];
            KB = $Properties[3];
            KBDescription = $Properties[4];
            ReleaseDate = $Properties[5];
        }

        $Tables += $Obj
    }
}

$Tables | ft