Solved

WSUS History

Posted on 2013-05-17
2
438 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:
Donald Stewart 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

I had a question today where the user wanted to know how to delete an SSL Certificate, so I thought that I would quickly add this How to! Article for your reference. WHY WOULD YOU WANT TO DELETE A CERTIFICATE? 1. If an incorrect certificate was …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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 new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

840 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