Public/Get-MicrosoftSsms.ps1
|
Function Get-MicrosoftSsms { <# .SYNOPSIS Returns the latest SQL Server Management Studio release version number and download. .DESCRIPTION Returns the latest SQL Server Management Studio release version number and download. .NOTES Author: Bronson Magnan Twitter: @cit_bronson .LINK https://github.com/aaronparker/Evergreen .EXAMPLE Get-MicrosoftSsms Description: Returns the latest SQL Server Management Studio for Windows version number and download URL #> [Alias("Get-MicrosoftSQLServerManagementStudio")] [OutputType([System.Management.Automation.PSObject])] [Diagnostics.CodeAnalysis.SuppressMessageAttribute("PSUseSingularNouns", "")] [CmdletBinding()] Param() # Get application resource strings from its manifest $res = Get-FunctionResource -AppName ("$($MyInvocation.MyCommand)".Split("-"))[1] Write-Verbose -Message $res.Name # SQL Management Studio downloads/versions documentation $Content = Invoke-WebContent -Uri $res.Get.Uri -Raw # Convert content to XML document If ($Null -ne $Content) { Try { [System.XML.XMLDocument] $xmlDocument = $Content } Catch [System.Exception] { Write-Warning -Message "$($MyInvocation.MyCommand): failed to convert feed into an XML object." } # Build an output object by selecting installer entries from the feed If ($xmlDocument -is [System.XML.XMLDocument]) { ForEach ($entry in $xmlDocument.feed.entry) { ForEach ($components in ($entry.component | Where-Object { $_.name -eq $res.Get.MatchName })) { # Follow the download link which will return a 301 $redirectUrl = Resolve-RedirectedUri -Uri $res.Get.DownloadUri # Check returned URL. It should be a go.microsoft.com/fwlink/?linkid style link If ($redirectUrl -match $res.Get.MatchFwlink) { $nextRedirectUrl = Resolve-RedirectedUri -Uri $redirectUrl # If this returned URL target is a file If ($nextRedirectUrl -match $res.Get.MatchFile) { # Construct the output; Return the custom object to the pipeline $PSObject = [PSCustomObject] @{ Version = $entry.Component.version Date = ([DateTime]::Parse($entry.updated)) Title = $entry.Title URI = $nextRedirectUrl } Write-Output -InputObject $PSObject } Else { Write-Warning -Message "Failed to return a useable URL from $redirectUrl." } } } } } } Else { Write-Warning -Message "$($MyInvocation.MyCommand): failed to read Microsoft SQL Server Management Studio update feed." } } |