0

Hello we have several WSUS server in our company and one of them is acting weird. Servers get patched but there is still status "Downloaded" or not even any status for the current month KBs in the WSUS console report if I open one computer details and the SQL query reports also don't show Installed states even though patching happened three weeks ago already ! Weirdly the Last status report date is fresh from today or yesterday, but the KB statuses don't get updated. Any idea what can be wrong and how to fix it?

Here is an example of one server, but seems like all are affected and it's hundreds of them enter image description here enter image description here

Vitas
  • 157
  • 1
  • 8
  • 24
  • Are you *sure* your clients do their `/reportnow` to the right server? Can you see clients sending reporets in your access log? – bjoster Apr 09 '21 at 16:06
  • how else would the date be current on the server if they reported somewhere else? The patches are being approved on this WSUS and this server is in registry on the clients. Which access.log do you mean? – Vitas Apr 11 '21 at 11:37

1 Answers1

0

is it just the WSUS or you use SCCM as well ? Either You probably have Windows Internal Database not being updated and the performance to the DB need to be improved. if so first download : https://go.microsoft.com/fwlink/?linkid=2142258 & Run this command : sqlcmd -S np:\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query –i "\location of your script\WSUSDBmntc.sql You can download it from here : https://github.com/vishalnvora/WSUSDBCleaner/blob/main/WSUSDBmntc.sql

VIX
  • 76
  • 1
  • so I have found out this is already there and scheduled to run twice per month. My colleague has set this up years ago already, so that's not the problem it seems :-\ – Vitas Apr 15 '21 at 09:23