Clearing the Synchronization history in the WSUS console

Clearing the Synchronization history in the WSUS console

You know how after you’ve been using WSUS for a while and you go into the admin console, then to the Synchronization node, you can end up waiting and waiting for the list to enumerate?  This is the list I’m talking about:

image

Have you ever wished you could just clear that list and start fresh?  Well with a simple SQL script now you can.  To do this, the first thing you’ll need to do is fire up the SQL Server Management Studio and connect to whatever server your WSUS server is using.  In my case I’m using SQL Server 2008 so mine looks like this:

image

Now if you’re using the Internal Database for WSUS then you’ll want to connect to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query which is what I did below:

image

Next navigate to the SUSDB database:

image

Right-click on SUSDB and select New Query:

image

In the Query windows enter and execute the following query:

USE SUSDB
GO
DELETE FROM tbEventInstance WHERE EventNamespaceID = '2' AND EVENTID IN ('381', '382', '384', '386', '387', '389')

Just paste those three lines in the window and hit the Execute button:

image

On my system I get this.  Note the success at the bottom:

image

 

 

 

 

 

 

 

 

That’s about all there is to it so you can go ahead and close the SQL Management Studio.  Now when you go to the WSUS admin console it should look something like this:

image

Just like new.  Of course every time you make changes to any database you should make a backup first and this is no different.  Also a special thanks to Joe Tindale for the script above.  Thanks Joe!

ref: http://blogs.technet.com/sus/archive/2009/03/04/clearing-the-synchronization-history-in-the-wsus-console.aspx

Other Language:
Borrar la historia de sincronización en la consola de WSUS (es-ES)

Leave a Comment
  • Please add 1 and 6 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • LeoPonti edited Revision 1. Comment: Add Other language

  • Maheshkumar S Tiwari edited Original. Comment: Added Tag

Page 1 of 1 (2 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Maheshkumar S Tiwari edited Original. Comment: Added Tag

  • LeoPonti edited Revision 1. Comment: Add Other language

Page 1 of 1 (2 items)