我在报废微软网站工作，我想获取SQL产品名称，如“SQL版本2012”使用他们的版本“11.0.6607.3”。
基本上我想用他们的版本搜索他们的产品名称。使用invoke-webrequest帮助我使用powershell。
先谢了
这是我曾经尝试过的

$url = "https://learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updates"
$html.content = Invoke-WebRequest  -Uri $url

# Find the table rows (tr) in the HTML
$rows = ($html.content).ParsedHtml.getElementsByTagName('tr')

# Define the version number to search for
$searchVersion = '11.0.5058.0'

# Loop through the rows and find the matching version number
foreach ($row in $rows) {
    $cells = $row.getElementsByTagName('td')
    if ($cells.Count -gt 1 -and $cells[1].innerText -match $searchVersion) {
        # The version number is found in the second cell of the row
        # Output the SQL Server version from the first cell of the same row
        Write-Output $cells[0].innerText
        break  # Exit the loop after the first match is found
    }
}