SCCM 2007: WSUS DB maintenance

For a while now the synchronization of updates which are initiated by SCCM via WSUS are terribly slow. It takes hours and hours after SCCM is ready to deploy new updates to the clients caused by a WSUS databases of which the last maintenance job was run probably after the installation a few years ago.

SCCM 2007: Only show Required Updates

In the Software Update search folders SCCM 2007 always shows updates which aren't required by any host in your environment.

Here's a quick howto so only required updates with a minimum of 1 are showed in the search folders.

SCCM 2007: Exclude updates from search folder

Every month there is a monthly maintenance evening when updates are applied to our Windows servers. A time consuming job is to check the search folder and exclude updates which gave errors on earlier scheduled maintenance days.This is not a basic functionality in SCCM 2007 but a custom trick can do the job to automaticly exclude these updates from the Software Update search folders.