Solved

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

Posted on 2010-08-16
4
614 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

In this article we want to have a look at the directory attributes which are used by Microsoft to store the so called Security Identifiers (SID). These SIDs plays an important role in delegating and granting permissions and in authentication of trus…
Welcome back!  My apologies for taking so long to write part two of this series; it's been a long time coming!  As I promised in Part 1, this article will focus on how to locate those elusive AD properties that you are searching for.  Why is this us…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

895 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now