Tuesday, August 21, 2007

WSUS Superseded Updates

The «WSUS Superseded Updates» tool allow you to connect remotely to a Windows Server Update Service (WSUS) version 3.0 and get a list of updates superseded by other update but that are still approved for installation.

Did you ever wonder if you forgot to declined an update that was superseded by an other one ? Well with WSUSSupersedeUpdates you can search for those pesky updates. Try it out, you might discover a few updates that you forgot about.

Requirements

To use WSUSSupersedeUpdates you need :

  • Microsoft .net Framework v2.0
  • A Windows Server Update Service (WSUS) v3.0
  • microsoft.updateservices.administration.dll (this dll gets installed when you install WSUS 3.0 Management Console)

Features

Multilanguage support. If you are using any of the supported language by WSUS 3.0 the update's titles will automatically be display in you current language.

List Updates since. You can limit your search to include only superseded updates publish since a special date. This is the update's creation date or publication by Microsoft)

List all updates. List all the superseded updates in the database

Updates superseded by an approved update only. All update where de superseding update(s) are not approved will be exclude from the search.

Normally if an old update is superseded by a new one and you approved the new one the older, you should decline new old one. But why would I want to search for updates that are superseded but by an update that is not approved ?

Take this case for example :

  • A new update 'B' is publish, 'B' is replacing 'A'.
  • You approved 'B', but you forgot to decline 'A'.
  • Later a new update 'C' is publish, 'C' is replacing 'B'.
  • You approved 'C' and decline 'B'.

Ah ah ! Update 'A' is still approved and it is superseded by a decline update. To find this update you should uncheck «Updates superseded by an approved update only».

Server connection settings. You can specify the server address, port and use of SSL for your WSUS server. Port 8530 and 8531(SSL) were used by default by WSUS 2.0. Port 80 and 443(SSL) are used by default by WSUS 3.0

Saved server connection settings. All server connection settings gets saved in a user.config file

Reset server settings. You can reset all server connection setting by clicking on the big settings button in the upper right corner.

Sorting updates. By clicking on any column header you can sort the the table accordingly.

Copy to clipboard. You can copy any cells or lines in the table by simply typing CTRL+C

Table column full description. You can move the mouse over any column header to see the full description of it's content.

Price

It's absolutely FREE ! If you like it just use it.

Download

You can find the latest version here

Version History

Version 1.0 Initial release

Copyright (C) Microsoft Corporation

The code used in this tool is vaguely based on the ListApprovedUpdates sample that is part of the Microsoft Windows Server Update Services 3.0 API Code Samples.

About me

I'm not a professional developer so be kind, there may be bugs in this tool. But if you gently report them to me I will gladly look at it.

WSUS Approval History Log

The «WSUS Approval History Log» tool allow you to connect remotely to a Windows Server Update Service (WSUS) version 3.0 and get a list of approvals made for updates.

In my organisation we are two WSUS administrators responsible of approving updates. Previously we were manually maintaining a text log of who approved witch update and when. Now I'm using WSUSApprovalHistoryLog, it save me a lot of time every month.

Requirements

To use WSUSApprovalHistoryLog you need :

  • Microsoft .net Framework v2.0
  • A Windows Server Update Service (WSUS) v3.0
  • microsoft.updateservices.administration.dll (this dll gets installed when you install WSUS 3.0 Management Console)

Features

Multilanguage support. If you are using any of the supported language by WSUS 3.0 the update's titles will automatically be display in you current language.

List Approvals since. You can limit your search to include only approvals made since a special date. This is not the date the update's arrival or publication, this is the date the approval action was made.

List all approvals. List all the approvals in the database

Server connection settings. You can specify the server address, port and use of SSL for your WSUS server. Port 8530 and 8531(SSL) were used by default by WSUS 2.0. Port 80 and 443(SSL) are used by default by WSUS 3.0

Saved server connection settings. All server connection settings gets saved in a user.config file

Reset server settings. You can reset all server connection setting by clicking on the big settings button in the upper right corner.

Sorting approvals. By clicking on any column header you can sort the the table accordingly.

Copy to clipboard. You can copy any cells or lines in the table by simply typing CTRL+C

Table column full description. You can move the mouse over any column header to see the full description of it's content.

Automatic Approval actions. You can fin automatic approvals made by the WSUS service by looking for the string "WUS Server" in the "By" column.

Price

It's absolutely FREE ! If you like it just use it.

Download

You can find the latest version here

Version History

Version 1.1Initial release

Limitations

Unfortunately WSUS seems to save only the Install and Remove action information in it's database. When you decline an update, the action is not recorded in the database; so WSUSApprovalHistoryLog can't show you those actions. Event worse, when you decline an update, all approval actions for that update are deleted. Sorry not my fault.

Copyright (C) Microsoft Corporation

The code used in this tool is greatly based on the ListApprovedUpdates sample that is part of the Microsoft Windows Server Update Services 3.0 API Code Samples.

The main differences are :

  • The search is based on the list of Approvals not on the list of Updates
  • A DataGridView is used instead of a ListView
  • You can change the server connection parameters
  • You can list all approvals
  • The tool has been renamed WSUSApprovalHistoryLog
  • Support for language localized update's metadata

About me

I'm not a professional developer so be kind, there may be bugs in this tool. But if you gently report them to me I will gladly look at it.