Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

WSUS History

Posted on 2013-05-17
2
Medium Priority
?
456 Views
Last Modified: 2016-02-20
I have an audit request for "System generated listing or a screenshot of Windows patches implemented from 1/1/2012 - 12/31/2012".  Is there a way to pull WSUS updates approved in that time frame?

We're using WSUS 3.2.7600.226 on a Windows 2008 R2 server.

I found a feature where I can create my own view of updates, but the only options for a time frame seem to be Last Week, Last Month, Last 2 Months.  

I assume this is a pretty standard audit request, how do other people handle this one?

Thanks in advance!
0
Comment
Question by:abcbev
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 47

Accepted Solution

by:
Donald Stewart earned 1500 total points
ID: 39174977
You could try the SQL query here

http://kapes.wordpress.com/2009/09/02/wsus-approval-history-report/

Or try


   Open a command prompt
   Type wmic qfe list full /format:htable > hotfixes.htm
   Then type hotfixes.htm
0
 

Author Closing Comment

by:abcbev
ID: 39188628
SQL Query did it, with some slight modification.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Suggested Courses

604 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