WSUS "updates with no status" weirdness

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.
John WAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MaheshArchitectCommented:
Updates with no Status
This usually means that since the time that the update was synchronized to the WSUS server, the computer has not contacted the WSUS server

http://technet.microsoft.com/en-us/library/cc708497(v=ws.10).aspx
0
John WAuthor Commented:
Thanks, I understand that, however, all PCs are regularly synchronizing.  Like I said, this only shows up this way on the "updates" node.  If I drill down to look at status of specific updates, it looks as you would expect with the highest numbers in the green of 'updates installed/not applicable'
I would think that if the computers weren't reporting, it would be showing up as 'computers or updates with no status' across the board.
0
John WAuthor Commented:
Here's an example of what I see in the updates node:

Update Node of WSUS
If I look at individual updates, I see plenty of installed/not applicable instances.  I would think that number should show up in the updates summary as well - certainly not 0.  It doesn't make sense.
0
Santosh GuptaCommented:
Hi,

pls try below command and then sync the wsus.


WSUSDebug PurgeUnneededFiles
WSUSUTIL.exe Deleteunneededrevisions
WSUSUTIL.exe Reset
WSUSUTIL.exe Removeinactiveapprovals

http://msmvps.com/blogs/athif/archive/2005/10/27/purge-delete-the-downloaded-patches-on-wsus-server.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John WAuthor Commented:
Thank you!  I actually ran a cleanup via the wizard and accomplished the same thing but I am positive your tasks would have worked and been the better way to do it.  All graphs look normal now.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.