Solved

VBS Script needed to check amount of windows updates needed on remote servers

Posted on 2010-08-16
4
616 Views
Last Modified: 2012-06-27
Hello eveyone,

I was wondering if someone knew of a script that I could use that would show me the amount of "critical" or "important" (no recommended basically) updates that a remote server needs. I would like to run a script from my machine, that would query any server or computer we have and send me a text file indicating something like " XZXServer needs 15 updates". If it could show the updates too , that would be awesome, but is not necessary..the count is the most important thing..this would help me eliminate the need to log onto 50 servers to see if updates were installed or not.
Servers are a mix of 2003,2008 64 and 32 bit..some R2, some not.

Thanks!
0
Comment
Question by:andrew054
  • 2
4 Comments
 
LVL 2

Expert Comment

by:SushiFrito
ID: 33448484
If you have WSUS installed, you can check in the SUSDB.

You can SELECT the 'summarizationstate' field with value = 3 or 6
0
 

Author Comment

by:andrew054
ID: 33449073
I am not following you..can you elaborate?
0
 
LVL 47

Accepted Solution

by:
Donald Stewart earned 500 total points
ID: 33451462
0
 

Author Closing Comment

by:andrew054
ID: 33455857
Exactly what I wanted, and more. Thanks for the link!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is pretty cool.  The purpose of this VB Script is to help you document where JAR (Java ARchive) files and specifically java class files are located so that you can address issues seen with a client or that you can speak intelligently with a dev…
This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question