What is WSUS Automated Maintenance?

WSUS Automated Maintenance (WAM) © is a software solution that takes the maintenance required for WSUS and automates it. It was created by Adam J. Marshall and is licensed on a yearly subscription basis through AJ Tek.

There are a number of different areas that require maintenance for WSUS. Some of them are:

  • Backing up the database.
  • If using the Drivers category, removing the current listed drivers to clean up the bulk of the drivers that are old and not used. New drivers will sync normally.
  • Declining multiple types of updates including superseded, beta, preview, expired and Itanium by default.
  • Compressing update revisions.
  • Cleaning up computer objects.
  • Renaming OS descriptions to make it easier to identify systems.
  • Cleaning up the synchronization logs with Microsoft.
  • Removing declined updates from the database.
  • Running the database maintenance routine.

  • Running the Server Cleanup Wizard (SCW)

WAM allows you to take back control of your WSUS instance (or SUP/DP instances in an SCCM environment) and frees up time for other priorities. If WSUS is not maintained properly, it will become slow, bloated, and cause errors that will take away valuable time from an IT Administrator to troubleshoot and resolve.

shadow

Features

Super Easy Installation

Guided installer for a simple installation experience. It also comes with an unattended installation procedure for easy deployment to multiple systems, or for server core installs.

Support Included

Support is included for active subscriptions on the latest version of the software.

Simple Configuration Experience

The installer handles the configuration experience. You take the standard installation (blue USB), all defaults are selected. You take the advanced configuration (red USB), you stay in WSUS-land and we show you just how far the WSUS hole goes. Remember: all we’re offering are plentiful options.

Indexes the WSUS Database

Add WSUS Index Optimization to the database to increase the speed of many database operations in WSUS by approximately 1000-1500 times faster.

Remove Drivers

Remove all existing drivers from the WSUS Database trimming down the number of updates in the database. If the Drivers classification is checked, new driver updates will sync and will be kept under control (Default; Optional).

Decline Multiple Types of Updates

Shrink your WSUSContent folder’s size by declining multiple types of updates including by default any superseded updates, expired updates, preview updates, Itanium updates, and Beta updates.

Remove Declined Updates

Remove declined updates from the WSUS Database.

Clean Synchronization Logs

Clean out all the synchronization logs that have built up over time (configurable, with the default keeping the last 14 days of logs).

Compress Update Revisions

This stream will use SQL code to execute Microsoft’s stored procedures that will return the update id of each update revision that needs compressing and then compress it.

Remove Obsolete Updates

This stream will use SQL code to execute Microsoft’s stored procedures that will return the update id of each obsolete update in the database and then remove it.

Computer Object Cleanup

Computer Object Cleanup (configurable, with the default of deleting computer objects that have not synced within 30 days).

Rename OS Descriptions

This stream will rename the operating system descriptions of client systems to something that is based on their editions and versions. This will rename Windows 10, Server 2008 R2, Server 2012, Server 2012 R2, Server 2016, and Server 2019.

Database Maintenance

Run the Recommended SQL database Maintenance script on the actual SQL database.

Server Cleanup Wizard

Runs the built-in Server Cleanup Wizard (SCW) to actually carry out the removal of files on the file system.

Latest News

New system administrators will have a varying degree of familiarity with WSUS. Some might have helped with Windows server admin tasks in previous roles while others might be learning everything on the job. When it comes to WSUS best practices, there is nothing more important than maintenance and regularly scheduling … Read More

When using your WSUS server, there are hundreds of possible errors you could encounter. Investigating WSUS errors and possible solutions can take up an enormous amount of your time, whether it’s through trial-and-error or searching forum articles on fixes for your specific, and often unique, situation. Instead of getting frustrated … Read More

Connecting to the Windows Internal Database (WID) can only be done LOCALLY. It cannot be done from a remote machine. This is one of the trade-offs for using WID over SQL Express (but SQL Express carries a hard database size limit where as the WID does not).
Using SQL Server Management … Read More

As a system administrator, are you tired of seeing “an error occurred trying to connect the WSUS server” or “the WSUS administration console has encountered an unexpected error” while working with WSUS? With our WSUS Automated Maintenance (WAM) software, you can free up space, avoid error messages and save time … Read More

Windows Update for Business (WUfB) is a new method of thinking about how updates are done. It is a fundamental switch in how you look at dealing with updates. It can make your life easier if you can just get over the fundamental switch in realizing that you have little … Read More

As Microsoft changes Windows 10 to use more Features on Demand (FOD), there will be a much larger pull to have these updates come directly from Microsoft. Currently (2019.02), feature on demand updates don’t flow down to WSUS specifically from 1809. I’m not entirely sure why because there are Windows … Read More

shadow

WSUS Automated Maintenance (WAM) © is a software solution that takes the maintenance required for WSUS and automates it. It was created by Adam J. Marshall and is licensed on a yearly subscription basis through AJ Tek.

There are a number of different areas that require maintenance for WSUS. Some of them are:

  • Backing up the database.
  • If using the Drivers category, removing the current listed drivers to clean up the bulk of the drivers that are old and not used. New drivers will sync normally.
  • Declining multiple types of updates including superseded, beta, preview, expired and Itanium by default.
  • Compressing update revisions.
  • Cleaning up computer objects.
  • Renaming OS descriptions to make it easier to identify systems.
  • Cleaning up the synchronization logs with Microsoft.
  • Removing declined updates from the database.
  • Running the database maintenance routine.

Running the Server Cleanup Wizard (SCW) WAM allows you to take back control of your WSUS instance (or SUP/DP instances in an SCCM environment) and frees up time for other priorities. If WSUS is not maintained properly, it will become slow, bloated, and cause errors that will take away valuable time from an IT Administrator to troubleshoot and resolve.

shadow

Features

Super Easy Installation

Guided installer for a simple installation experience. It also comes with an unattended installation procedure for easy deployment to multiple systems, or for server core installs.

Support Included

Support is included for active subscriptions on the latest version of the software.

Simple Configuration Experience

The installer handles the configuration experience. You take the standard installation (blue USB), all defaults are selected. You take the advanced configuration (red USB), you stay in WSUS-land and we show you just how far the WSUS hole goes. Remember: all we’re offering are plentiful options.

Indexes the WSUS Database

Add WSUS Index Optimization to the database to increase the speed of many database operations in WSUS by approximately 1000-1500 times faster.

Remove Drivers

Remove all existing drivers from the WSUS Database trimming down the number of updates in the database. If the Drivers classification is checked, new driver updates will sync and will be kept under control (Default; Optional).

Decline Multiple Types of Updates

Shrink your WSUSContent folder’s size by declining multiple types of updates including by default any superseded updates, expired updates, preview updates, Itanium updates, and Beta updates.

Remove Declined Updates

Remove declined updates from the WSUS Database.

Clean Synchronization Logs

Clean out all the synchronization logs that have built up over time (configurable, with the default keeping the last 14 days of logs).

Compress Update Revisions

This stream will use SQL code to execute Microsoft’s stored procedures that will return the update id of each update revision that needs compressing and then compress it.

Remove Obsolete Updates

This stream will use SQL code to execute Microsoft’s stored procedures that will return the update id of each obsolete update in the database and then remove it.

Computer Object Cleanup

Computer Object Cleanup (configurable, with the default of deleting computer objects that have not synced within 30 days).

Rename OS Descriptions

This stream will rename the operating system descriptions of client systems to something that is based on their editions and versions. This will rename Windows 10, Server 2008 R2, Server 2012, Server 2012 R2, Server 2016, and Server 2019.

Database Maintenance

Run the Recommended SQL database Maintenance script on the actual SQL database.

Server Cleanup Wizard

Runs the built-in Server Cleanup Wizard (SCW) to actually carry out the removal of files on the file system.

Latest News

New system administrators will have a varying degree of familiarity with WSUS. Some might have helped with Windows server admin tasks in previous roles while others might be learning everything on the job. When it comes to WSUS best practices, there is nothing more important than maintenance and regularly scheduling … Read More

When using your WSUS server, there are hundreds of possible errors you could encounter. Investigating WSUS errors and possible solutions can take up an enormous amount of your time, whether it’s through trial-and-error or searching forum articles on fixes for your specific, and often unique, situation. Instead of getting frustrated … Read More

Connecting to the Windows Internal Database (WID) can only be done LOCALLY. It cannot be done from a remote machine. This is one of the trade-offs for using WID over SQL Express (but SQL Express carries a hard database size limit where as the WID does not).
Using SQL Server Management … Read More

As a system administrator, are you tired of seeing “an error occurred trying to connect the WSUS server” or “the WSUS administration console has encountered an unexpected error” while working with WSUS? With our WSUS Automated Maintenance (WAM) software, you can free up space, avoid error messages and save time … Read More

Windows Update for Business (WUfB) is a new method of thinking about how updates are done. It is a fundamental switch in how you look at dealing with updates. It can make your life easier if you can just get over the fundamental switch in realizing that you have little … Read More

As Microsoft changes Windows 10 to use more Features on Demand (FOD), there will be a much larger pull to have these updates come directly from Microsoft. Currently (2019.02), feature on demand updates don’t flow down to WSUS specifically from 1809. I’m not entirely sure why because there are Windows … Read More

shadow