WSUS(Windows Server 2019) - Cleanup - fails every time 'Unused updates and update revisions' is selected.

Steen Jensen 21 Reputation points
2021-05-10T07:55:16.25+00:00

I'm experiencing the above - a classic. I once managed to download a SQL script that actually solved the problem. For some reason there was fields with negative values like '-1' in some table that the WSUS server cleanup wizard couldn't handle.

I simply cannot remember where I got it from last time :-)

Is there someone in here who could provide that script or a link?

Thanks in advance.

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,201 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Adam J. Marshall 8,721 Reputation points MVP
    2021-05-11T03:39:04.58+00:00

    What maintenance are you currently performing? Server Cleanup Wizard (SCW), declining superseded updates, running the SQL Indexing script, etc.?

    https://www.ajtek.ca/wsus/how-to-setup-manage-and-maintain-wsus-part-8-wsus-server-maintenance/

    There's not one 'script' that will fix it all as each part of the maintenance requires something different.

    1 person found this answer helpful.
    0 comments
  2. Rita Hu -MSFT 9,626 Reputation points
    2021-05-10T09:33:04.007+00:00

    anonymous userJensen-8656
    Thanks for your posting on Q&A.

    Here is a related link for your reference. Please follow the link to maintenance the WSUS server first.

    Hope the above will be helpful.

    Thanks for your time and wish you have a nice day :)

    Regards,
    Rita

    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
  3. Steen Jensen 21 Reputation points
    2021-05-10T12:27:10.333+00:00

    Hi Rita :-)

    Thanks for your quick reply.

    I'd been through this guide allready without any success. Again what I neeed is this particular SQL that can clean up the way I mentioned.

    It's a commonly known/experienced issue I believe. Except that I'm not able to findt that SQL anymore.

    Best Regards
    Steen Jensen

  4. Steen Jensen 21 Reputation points
    2021-05-11T12:58:38.13+00:00

    Hi Adam,

    Thanks for your reply. I'm doing the SCW first step. Rest of them works just fine. Please look my last correspondance with Rita.

    Best Regards,
    Steen Jensen