SPQuery organizes and installs service packs and hotfixes.

Track Those Hotfixes

SPQuery organizes and installs service packs and hotfixes.

If you're running servers with Windows as an operating system, particularly if those servers are connected to the Internet, you know that you can't just install Windows and walk away. These days, you have to keep up with a confusing array of service packs and hotfixes to prevent crackers from walking all over your Windows installation. But how do you keep track of which servers have had which fixes installed, and what's available that you should know about? Sure, you can keep an eye on Microsoft's web site, but if you're a busy administrator responsible for multiple servers, St. Bernard Software's SPQuery 4.0 offers a much better solution.

SPQuery is a complete manager for Windows updates for all varieties of Windows NT 4.0 and Windows 2000, including Terminal Servers as well as regular servers. For starters, you can use it to see the exact status of all of the computers on your network: which operating system they're running, which service packs have been installed, and which hotfixes have been installed on top of those service packs. This information can be presented in a variety of reports and formats. One especially useful report lets you select hotfixes that you're especially interested in and see which servers need to have those particular hotfixes installed.

SPQuery can tell you which computers on your network are missing critical hotfixes, and then deploy those hotfixes straight to those computers. (Click image to see larger version.)

SPQuery also handles downloading and installing hotfixes. You can read the appropriate KnowledgeBase articles to determine whether you need a hotfix within the SPQuery interface, then download that hotfix and deploy it to as many computers as you like with just a few mouse clicks. You can even remotely reboot those computers if you need to do so in order to complete the installation. A nice added feature lets you use this same deployment engine to install your own software to servers around your network.

Finally, SPQuery will proactively track new hotfixes for you. Each time you launch the program, it queries a database at St. Bernard's web site, and then notifies you if new hotfixes are found that pertain to computers on your network. Click the "Update" button and SPQuery will download all the relevant information to your computer.

Anyone responsible for multiple Windows servers connected to the Internet needs to have a plan for keeping the operating system up to date. SPQuery offers a simple solution to the problem in an easy-to-master package. You can download a 15-day trial version from the St. Bernard web site.

About the Author

Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.


  • Spaceflight Training in the Middle of a Pandemic

    Surprisingly, the worldwide COVID-19 lockdown has hardly slowed down the space training process for Brien. In fact, it has accelerated it.

  • Surface and ARM: Why Microsoft Shouldn't Follow Apple's Lead and Dump Intel

    Microsoft's current Surface flagship, the Surface Pro X, already runs on ARM. But as the ill-fated Surface RT showed, going all-in on ARM never did Microsoft many favors.

  • IT Security Isn't Supposed To Be Easy

    Joey explains why it's worth it to endure a little inconvenience for the long-term benefits of a password manager and multifactor authentication.

  • Microsoft Makes It Easier To Self-Provision PCs via Windows Autopilot When VPNs Are Used

    Microsoft announced this week that the Windows Autopilot service used with Microsoft Intune now supports enrolling devices, even in cases where virtual private networks (VPNs) might get in the way.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.