Solved

WSUS History

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
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 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 tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

688 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