Solved

WSUS History

Posted on 2013-05-17
2
435 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
unknown svchost service useing lot of network resources 12 74
Auto Login Script 3 40
SQL Server 2012 r2 - Sum causes too much time 5 42
Problem to setup GUI 11 32
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 article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

770 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