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 back to PowerShell as DataSet.
Getting ready
In this recipe, we will be working with a WSUS server with one or more clients. Specifically, we will be querying the Windows Internal Database which is used by the default installation of WSUS.
