I wound up fixing the problem myself.
At one point all Dell and HP models were selected to sync. When you modify the 3rd party update subscription, and only select certain models to sync, WSUS does not remove the updates associated with the models you unselected. Once they are in WSUS, they are there for good.
While doing research I found a free utility created by Patch My PC that allows you to delete 3rd party updates from WSUS.
https://patchmypc.com/how-to-remove-third-party-updates-from-wsus-and-sccm
Here's a video explaining how to use the tool.
https://www.youtube.com/watch?v=S3kHKNDShyE
Based on the above, these are the steps I took to resolve my problem.
- In CM remove all deployments of 3rd party updates
- Unsubscribe from all 3rd party update catalogs
- Modify the properties of the SUP and uncheck all 3rd party catalogs on the Products tab
- On the SUP, under All Software Updates, run Synchronize Software Updates
- Verify all 3rd party updates in CM are expired
- Load the Patch My PC tool and delete all declined updates. In my case there were 29,000 declined 3rd party updates. After doing so, I noticed there were still 6,000+ 3rd party updates enabled. These were the ones that kept synching.
- Decline ALL 3rd party updates in the Patch My PC tool and then delete them using the tool. This left no 3rd party updates in WSUS
- On the SUP, under All Software Updates, run Synchronize Software Updates
- Monitor the wsyncmgr.log and wait for the sync to finish
- Once I got to this point, I was at a clean state in CM and WSUS related to 3rd party updates
- Subscribe to the Dell catalog, select the models you want, and perform a sync
- Monitor the SMS_ISVUPDATES_SYNCAGENT.log and wait for the sync to finish
- On the SUP, under All Software Updates, run Synchronize Software Updates
- Monitor the wsyncmgr.log and wait for the sync to finish
- Modify the properties of the SUP and select Dell on the Products tab
- On the SUP, under All Software Updates, run Synchronize Software Updates
- Monitor the wsyncmgr.log and wait for the sync to finish
- Repeat steps 11-17 for HP and Lenovo catalogs
After doing the above, I verified the updates for only the models I selected were enabled in CM. All of the other updates show as expired in the CM console and will be removed automatically during the next CM weekly cleanup process.
My CM console now has 204 Dell, 83 HP and 23 Lenovo updates available for deployment.
Scott