Some WSUS Products now have duplicate titles (i.e. Windows Server 2019)

You can differentiate the two products based on Parent Category
then incorporate IDs for comparison

[void][reflection.assembly]::LoadWithPartialName("Microsoft.UpdateServices.Administration")
$wsus = [Microsoft.UpdateServices.Administration.AdminProxy]::GetUpdateServer()
$DesiredProducts = ($wsus.GetUpdateCategories() | Where {$_.Title -EQ "Windows"}).GetSubcategories() | Where {$_.Title -EQ "Windows Server 2019"} | Select Title, ID
Write-Host "Desired products to be enabled:`n $($DesiredProducts.Title)"

$Wsus = Get-WsusServer
$Subscription = $Wsus.GetSubscription()
$EnabledProducts = $Subscription.GetUpdateCategories() | Select Title, ID
Write-Host "The following products are currently enabled: $($EnabledProducts.Title -Join '; ')"

$Differences = @(compare $EnabledProducts $DesiredProducts -Property Title, ID)
If ($Differences.Count -gt 0) {
    # product list doesn't match- Show the differences, then correct them
    $DiffTable = $Differences | Select @{Name="Product";Expression={$_.Title}} , @{Name="Difference";Expression={If($_.SideIndicator -eq "<=") {"Extra Product"} Else {"Missing Product"}}} | Format-Table | Out-String
    Write-Host "Diffrerences between Current Product settings and Desired product settings:`n$DiffTable" -ForegroundColor Cyan
    foreach ($Difference in $Differences) {
         $ProductTitle = $Difference.Title
         $ProductID = $Difference.ID.Guid
         $ProductObj = Get-WsusProduct | where {$_.Product.ID -eq $ProductID}
         If (-not ([bool] $ProductObj)) {
             Write-Error "Product '$ProductTitle' is not a product WSUS knows about.  You may need to perform a Category Synchronization to discover new product definitions."
         } Else {
             If($Difference.SideIndicator -eq "<=") {
                 # Extra product - Disable it
                 Write-Host "Disabling extra product: '$ProductTitle'"
                 $ProductObj | Set-WsusProduct -Disable -Verbose
             } Else {
                 # Missing product - Enable it
                 Write-Host "Enabling missing product: '$ProductTitle'"
                 $ProductObj | Set-WsusProduct -Verbose
             }
         }
    }
} Else {
     #Product list matches
     Write-Host "No WSUS product changes required." -ForegroundColor Green
}

Hi blueblade-8067,

Thanks for your posting on Q&A.

In order to help me research further, please consider providing the associated screenshot of the duplicate titles phenomenon and related error information.

Thanks for your understanding and cooperation.

Regards,
Rita

No problem @Rita Hu -MSFT ; Attached are some screenshots of the duplicate products under different categories.

My script doesn't actually error out, but performs the wrong operations due to duplicate titles. It accepts a list of products you want enabled in WSUS, compares that list to the currently enabled products, and then enables the missing products and disables the extra products.

$DesiredProducts = @('Windows Server 2019')  
Write-Host "Desired products to be enabled:`n $DesiredProducts"  
$Wsus = Get-WsusServer  
$Subscription = $Wsus.GetSubscription()  
$EnabledProducts = @($Subscription.GetUpdateCategories() | foreach {$_.Title})  
Write-Host "The following products are currently enabled: $($EnabledProducts -Join '; ')"  
$Differences = @(compare $EnabledProducts $DesiredProducts)  
If ($Differences.Count -gt 0) {  
    # product list doesn't match- Show the differences, then correct them  
    $DiffTable = $Differences | Select @{Name="Product";Expression={$_.InputObject}} `  
    , @{Name="Difference";Expression={If($_.SideIndicator -eq "<=") {"Extra Product"} Else {"Missing Product"}}} `  
    | Format-Table | Out-String  
    Write-Host "Diffrerences between Current Product settings and Desired product settings:`n$DiffTable" -ForegroundColor Cyan  
    foreach ($Difference in $Differences) {  
        $ProductTitle = $Difference.InputObject  
        $ProductObj = Get-WsusProduct | where {$_.Product.Title -eq $ProductTitle}  
        If (-not ([bool] $ProductObj)) {  
            Write-Error "Product '$ProductTitle' is not a product WSUS knows about.  You may need to perform a Category Synchronization to discover new product definitions."  
        } Else {  
            If($Difference.SideIndicator -eq "<=") {  
                # Extra product - Disable it  
                Write-Host "Disabling extra product: '$ProductTitle'"  
                $ProductObj | Set-WsusProduct -Disable -Verbose  
            } Else {  
                # Missing product - Enable it  
                Write-Host "Enabling missing product: '$ProductTitle'"  
                $ProductObj | Set-WsusProduct -Verbose  
            }  
        }  
    }  
} Else {  
    #Product list matches  
    Write-Host "No WSUS product changes required." -ForegroundColor Green  
}  

The script always takes the wrong action-- it either sees Windows 2019 as missing and enables 2, or it sees Windows 2019 as extra and disables both.

Sorry for hijacking the question, but I am struggling with my Ansible-modules for WSUS, and this duplicate title debacle has made me have to move over to working with "Id" in my parameters, ruining the human readability in YAML.

Another reason for that, is the brilliant idea of using a dash thats not a dash in a category name: Windows Server Manager – Windows Server Update Services (WSUS) Dynamic Installer

https://github.com/dsccommunity/UpdateServicesDsc/issues/47