Clearing the Synchronization history in the WSUS console

When you using WSUS for a long time and go into admin console to the Synchronization node - it loads very long time.

I’m talking about:

You can clean the WSUS synchronization history from database.

To do this, you’ll need to run SQL Server Management Studio and connect to SQL-server your WSUS server is using.

Note:

If you’re using the Internal Database for WSUS then you connect to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

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')

This query will clear WSUS Synchronization history.

Now when you go to the WSUS admin console it should look something like this:

To clear synchronization history  from a spesific date and older use query like this:

USE SUSDB

GO

DELETE FROM tbEventInstance WHERE EventNamespaceID = '2' AND EVENTID IN ('381', '382', '384', '386', '387', '389') AND TimeAtServer < '2019-02-16'

After this query WSUS admin console synchronization history look like:

Of course every time you make changes to any database you should make a backup first.