How to clean SUSDB from 3rd party updates

Pavel yannara Mirochnitchenko 11,716 Reputation points
2021-02-02T09:01:32.607+00:00

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.

Microsoft Configuration Manager Updates
Microsoft Configuration Manager Updates
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Updates: Broadly released fixes addressing specific issue(s) or related bug(s). Updates may also include new or modified features (i.e. changing default behavior).
962 questions
Microsoft Configuration Manager
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sherry Kissinger 3,806 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.

  2. Pavel yannara Mirochnitchenko 11,716 Reputation points
    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.

  3. R0930 1 Reputation point
    2021-12-29T14:23:23.96+00:00

    Any updates on this? Are the metadata-only (blue ones) updates really part of the WSUS database and need to be cleaned up?