Windows Server 2012 Automation with PowerShell Cookbook

Creating an update report

Windows update server contains multiple built-in reports that provide administrators with many of the details needed to perform their jobs. However, rare cases do exist where the built-in reports don't fit your specific needs and a custom report must be created.

One example of needing a custom report is searching for systems missing a certain update. This report could then be automatically processed by a script that would initiate installation of the updates on the clients. Using PowerShell, this process can be done in a single step.

In this recipe, we will be directly querying the WSUS database on the update server by using PowerShell. We will be using a SQL query to generate our custom report and then returning the information ...