Any updates on this? Are the metadata-only (blue ones) updates really part of the WSUS database and need to be cleaned up?
How to clean SUSDB from 3rd party updates
I have 3rd party updates metadata only synced, and they are still have a blue icon. I need those to get expired and then deleted. Currently well known SUSDB powershell and SQL query scripts to clean the database are not effecting the entities with blue icon. Any idea?
I have 3300 items synced from Lenovo 3rd party and it breakes by OSD because of max round trip exeeded in WSUS.
3 answers
Sort by: Newest
-
-
Pavel yannara Mirochnitchenko 11,716 Reputation points MVP
2021-02-08T07:16:23.49+00:00 The solution I found is that you unscribe, de-select all catagories and products and re-sync.
-
Sherry Kissinger 3,886 Reputation points
2021-02-02T15:32:21.41+00:00 A possibility only; it's at least something to look at maybe.
I'm assuming that perhaps you utilized "System Center Updates Publisher" to originally publish those updates into CM as metadata only?
Run SCUP as Admin.
Option 1:
If this scup instance is referencing the original scup database, you might be lucky that you'll see all the lenovo updates you had previously sync'd. You should be able to expire there within SCUP there, and sync.Option 2 (if none of the lenovo things are listed in scup):
Go to the pull-down upper left, Options, Advanced.
click on "Start" within the Software Update Cleanup Wizard box there.If you are super lucky... the updates you want to expire will be listed there; and you can follow the directions to expire them there.