Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Patch Manager > Create a custom Windows Server Update Services (WSUS) report

Create a custom Windows Server Update Services (WSUS) report

Overview

This article describes how to create custom Patch Manager reports using the Report Definition Builder. You can create a Windows Server Update Services (WSUS) report that displays all pending updates, update IDs and update revision numbers in your environment. By adding these values, you can install updates directly from the Report Viewer.

Before you generate a report, schedule and run at least one inventory task for your managed computers. See Schedule inventory tasks to populate empty reports for additional information about how to schedule inventory tasks in Patch Manager,

Environment

All Patch Manager versions

Steps

Create a custom WSUS report

Perform the following procedure to select and order fields prior to clicking New Report.

  1. Log in to the Patch Manager Admin Console.
  2. In the navigation menu, expand Administration and Reporting > Reporting > WSUS Reports.
  3. Select a report category.
  4. In the Reports pane, select the report you want to create. 
  5. In the Actions pane, click New Report.
  6. In the Report Definition Builder window, select the fields you want to include in the report.
  7. Specify the Column-and-sort-order for your fields.
  8. Apply any filters you want to save in your report, and then click Next.
  9. Name the report.
  10. Specify any Scheduling preferences, and then click Finish. 

 

Create a custom report that displays all pending updates

  1. Log in to the Patch Manager Admin Console.
  2. In the navigation menu, expand Administration and Reporting > Reporting > WSUS Reports.
  3. Select Windows Server Update Services Analytics.
  4. In the Reports pane, select Select Computer Update Status.
  5. Under Available Datasources, select Computer Update Status With Update Information.
  6. In the Available Fields section, press Ctrl + click to select the following fields in this order:
    1. Computer Name
    2. Update Title
    3. Update Installation State (Friendly Name)
    4. Update ID
    5. Update Revision Number
    6. Name (Update Server)
  7. In the Actions pane, click New Report.
  8. Apply your preferences to one of the columns.
    1. Click Not Sorted next to the Column Name.
    2. Hover to Sort Position 1, and then select a sort option. 
  9. Add a filter to the report for updates that will install after the approval.
    1. Select and expand the filter criteria for the report.
    2. Click Select field for the new filter entry.
    3. Hover to Computer Update Status With Update Information, and then select Update Approval Action (Friendly Name).
    4. Click Select Operator > Select Equals.
    5. Click Enter Value > Enter Value. 
    6. Enter Install
  10. Add a filter to the report for updates with Uninstalled or Unknowns states.
    1. Expand the existing filter.
    2. Click Select Field for the new filter entry.
    3. Hover to Computer Update Status With Update Information, and then select Update Installation State (Friendly Name).
    4. Click Select Operator > Does not equal.
    5. Click Enter Value > Enter Value.
    6. Enter Installed.
    7. Click the arrow and then select Place in New Group.
    8. In the new group, click [ + ]. 
    9. Click Select Field for the new filter entry.
    10. Hover to Computer Update Status With Update Information, and then select Update Installation State (Friendly Name).
    11. Click Select Operator > Does not equal.
    12. Click Enter Value > Enter Value.
    13. Enter Unknown.
  11. Click Next.
  12. Enter a unique name in the Report Name field. For example, Computers to update. 
  13. Select Save and run report now. 
  14. Click Finish.

 

 

Last modified

Tags

Classifications

Public