I’ve been looking for a little while at removing software update types no longer used in SMS (now that I’ve implemented ITMU). There are 2 in particular – MS04-028 & MS05-FEB. I haven’t yet been able to remove them from the Distribute Updates Wizard, but have removed them from the Software Updates screen.
If you jump into your SQL Enterprise Manager and run a query like below, you’ll get all the results (a ton), but the ones I wanted were near the top:
SELECT *, ScanAgent00 AS Expr1
FROM Software_Updates_DATA
ORDER BY ScanAgent00
Now, I wanted to remove items with ScanAgent00 = ‘MS04-028 Update Scan Tool’ & ‘MS05-009 Update Scan Tool’, so run something like below and then select and delete:
SELECT *, ScanAgent00 AS Expr1
FROM Software_Updates_DATA
WHERE (ScanAgent00 = ‘MS05-009 Update Scan Tool’)
