WSUS "updates with no status" weirdness
Posted on 2014-02-26
Several months ago, I completely reinstalled our primary WSUS box on 2008 R2. All works well, machines are updated, targeting puts them into the right groups and so forth. EXCEPT: if I click on "updates" under update services/<server name>/ in the console, I get no statistics for 'updates installed/not applicable'. Each reading for "Updates installed/not applicable" is 0 and greyed out in each category: All Updates, Security Updates, Feature Packs, Critical Updates, WSUS Updates and Service Packs. Updates with no status numbers are quite high.
However, here's where it gets strange. If I go into the lower categories and go through update by update or even computer by computer, I get the expected values for updates installed/not applicable for each individual update. The only place it isn't reporting correctly is that first screen summarizing updates.
You can imagine that this is a tough one to find an answer for. Any ideas? Is there a way to clear the database and let all computers check in again? I want to stress again, that everything is working except this one reporting piece - which just so happens to be very helpful for an at-a-glance- view of everything.