SCCM Build 2010 Duplicate Windows Products In Software Update Database

Thomas Butterfield 1 Reputation point


In SCCM (Build 2010) I create ADR's every month for our server patching using a scripted process and this month (December 2020) it began to fail.

It seems when creating an ADR using the SCCM PS Module the cmdlet is matching duplicate entries for "Windows Server 2016" and "Windows Server 2019".

New-CMSoftwareUpdateAutoDeploymentRule : The parameters specified matches more than one collection.
At line:11 char:5

  • New-CMSoftwareUpdateAutoDeploymentRule `
  • ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  • CategoryInfo : LimitsExceeded: (Microsoft.Confi...mentRuleCommand:NewSoftwareUpda...mentRuleCommand) [New-CMSoftwareUpdateAutoDeploymentRule], Argu
  • FullyQualifiedErrorId : TooManyResults,Microsoft.ConfigurationManagement.Cmdlets.Sum.Commands.NewSoftwareUpdateAutoDeploymentRuleCommand

My question is how do I cleanup / remove the duplicate products entries and has anyone else come across this issue?


Microsoft Configuration Manager
0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. AllenLiu-MSFT 35,116 Reputation points Microsoft Vendor

    @Thomas Butterfield
    Thank you for posting in Microsoft Q&A forum.
    Yes, it seems a random issue for different SCCM version, I have two SCCM labs, version 2010 works well but version 2006 has the same issue.
    And @Jason Sandys has opened a bug on this issue.
    For the details, you may refer to this thread:

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Prajwal Desai [MVP] 11 Reputation points

    The issue is observed when you have ConfigMgr 2002 as well. So I don't think the issue is related to ConfigMgr build.

  3. Prajwal Desai [MVP] 11 Reputation points

    Thanks Jason. I will be publishing a post letting others know that they don't need to panic if they notice this issue.

    0 comments No comments

  4. Prajwal Desai [MVP] 11 Reputation points

    Workaround for ConfigMgr SUP showing duplicate entries for Windows Products. Thanks to Jason Sandys for providing additional info -

    0 comments No comments

  5. Viktor 1 Reputation point

    I'm not sure this is a problem only in WSUS, because I have the following error with double found malware

    0 comments No comments