SCCM Build 2010 Duplicate Windows Products In Software Update Database

Thomas Butterfield 1 Reputation point
2020-12-20T17:24:25.343+00:00

Hello,

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
    mentException
  • 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?

49752-sccm-duplicate-products.jpg

Microsoft Configuration Manager
0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AllenLiu-MSFT 40,316 Reputation points Microsoft Vendor
    2020-12-21T07:21:19.447+00:00

    @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:
    https://learn.microsoft.com/en-us/answers/questions/197708/how-can-i-download-updates-for-windows-10-2004.html

    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
  2. Prajwal Desai [MVP] 16 Reputation points
    2021-01-22T15:26:01.137+00:00

    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] 16 Reputation points
    2021-01-22T15:44:33.507+00:00

    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
  4. Prajwal Desai [MVP] 16 Reputation points
    2021-01-22T16:35:03.55+00:00

    Workaround for ConfigMgr SUP showing duplicate entries for Windows Products. Thanks to Jason Sandys for providing additional info - https://www.prajwaldesai.com/configmgr-sup-shows-duplicate-entries/

    0 comments
  5. Viktor 1 Reputation point
    2021-02-25T12:57:05.84+00:00

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

    0 comments