SCCM Build 2010 Duplicate Windows Products In Software Update Database

Question

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?

Answer 1

@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.

Answer 2

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

Answer 3

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

Answer 4

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/

Answer 5

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