Solved

WSUS History

Posted on 2013-05-17
2
430 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
2 Comments
 
LVL 47

Accepted Solution

by:
dstewartjr earned 500 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

Promote certifications in your email signature

Has your company recently won an award or achieved a certification? They'll no doubt want to show it off. Email signature images used to promote certifications & awards can instantly establish credibility with a recipient and provide you with numerous benefits.

Join & Write a Comment

Redirected folders in a windows domain can be quite useful for a number of reasons, one of them being that with redirected application data, you can give users more seamless experience when logging into different workstations.  For example, if a use…
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

708 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

11 Experts available now in Live!

Get 1:1 Help Now