Script to Delete Obsolete WSUS Updates

Delete Obsolete WSUS Updates.sql

-- This script deletes all obsolete WSUS updates from a WSUS database.
-- For more information, visit http://thebashfuladmin.com/2016/05/13/workaround-for-wsus-sql-timeout-errors/

USE SUSDB

DECLARE @UpdateID INT 
DECLARE @message varchar(1000) 

PRINT 'Create table'
CREATE TABLE #ObsoleteUpdatesToCleanup (UpdateID INT) 

PRINT 'insert table'
INSERT INTO #ObsoleteUpdatesToCleanup(UpdateID) EXEC spGetObsoleteUpdatesToCleanup 

PRINT 'declare deletes'
DECLARE DeleteUpdates CURSOR FOR SELECT UpdateID FROM #ObsoleteUpdatesToCleanup 

PRINT 'open deletes'
OPEN DeleteUpdates 
	
	PRINT 'fetch next'
	FETCH NEXT FROM DeleteUpdates INTO @UpdateID WHILE (@@FETCH_STATUS > -1) 
	
	BEGIN SET @message = 'Deleting update ' + CONVERT(VARCHAR(10), @UpdateID) RAISERROR(@message,0,1) WITH NOWAIT 
		PRINT @message
		EXEC spDeleteUpdate @localUpdateID=@UpdateID 
		FETCH NEXT FROM DeleteUpdates INTO @UpdateID 
	END 

PRINT 'close deletes'
CLOSE DeleteUpdates 

PRINT 'dealloc deletes'
DEALLOCATE DeleteUpdates 

DROP TABLE #ObsoleteUpdatesToCleanup

modified with print because it takes forever and unknown status of processing.

also check https://community.spiceworks.com/how_to/103094-automate-wsus-cleanup