wsus
Check Windows Update Settings on Remote PCs / Servers
Submitted by justin on Fri, 03/19/2010 - 10:31A common task for I.T. people is managing updates for their Windows servers and workstations. While WSUS is nice, free tool it does lack some advanced reporting. Another issue is that if a workstation or server hasn't ever contacted or isn't using WSUS, you can't get a grasp on it's status.
How to connect to the WSUS database using SQL tools
Submitted by justin on Tue, 09/15/2009 - 13:36On ocassion you may need to connect to the WSUS database. There have been times where you run into consistency errors that need to be corrected using the SQL Management Studio. Not a big deal if your database resides on a full blown SQL Server instance. If you're using the Windows Internal database installation, its not quite as straightforward.
Here's how to connect: