Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Patch Manager > Create a custom report using the Patch Manager Report Definition Builder

Create a custom report using the Patch Manager Report Definition Builder

Created by Seamus.Enright, last modified by MindTouch on Jun 23, 2016

Views: 736 Votes: 1 Revisions: 4

Overview

Use the Report Definition Builder to create custom Patch Manager reports. Use the example in this article to create a WSUS report that shows all of the pending updates in your environment, along with their Update IDs and Update Revision Numbers. By including these values, you can install the updates directly from Report Viewer.

Environment

Patch Manager

 

Steps

To create a custom WSUS report (general procedure):

  1. In the left pane of the Patch Manager console, expand the WSUS Reports node.
  2. Select the type of report you want to create.
  3. In the Actions pane (right), click New ReportNote: The example in this article illustrates how you can select and order fields prior to clicking New Report.
  4. In the Report Definition Builder window, select the fields you want to include.
  5. Specify the column- and sort-order for your fields.
  6. Apply any filters you want to save in your report.
  7. Click Next.
  8. Name the report.
  9. Specify any scheduling preferences.
  10. Click Finish.

To create a custom report that shows all pending updates (example):

  1. In the left pane of the Patch Manager console, expand Administration and Reporting > Reporting > WSUS Reports.
  2. Select Windows Server Update Services Analytics.
  3. In the center pane, select Computer Update Status.
  4. Under Available Datasources, select Computer Update Status With Update Information.
  5. Under Available Fields, use 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)
  6. In the Actions pane (right), click New Report.
  7. Apply a sort preference to one of the columns:
    1. Click Not Sorted next to the column name.
    2. Point to Sort position 1, and then select a sort option.
  8. Add a filter to the report for updates that will install upon approval:
    1. Click [+] under Select the filter criteria for the report.
    2. Click Select Field for the new filter entry.
    3. Point to Computer Update Status With Update Information, and then select Update Approval Action (Friendly Name).
    4. Next to the new field name, click Select Operator, and then select equals.
    5. Next to the new operator, click Enter Value, and then select Enter Value.
    6. In the text box, enter Install.
  9. Add a filter to the report for updates with states that are not Installed or Unknown:
    1. Click [+] next to the existing filter.
    2. Click Select Field for the new filter entry.
    3. Point to Computer Update Status With Update Information, and then select Update Installation State (Friendly Name).
    4. Next to the new field name, click Select Operator, and then select does not equal.
    5. Next to the new operator, click Enter Value, and then select Enter Value.
    6. In the text box, enter Installed.
    7. Click the arrow to the left of this filter, and then select Place in New Group.
    8. Click [+] within the new group.
    9. Click Select Field for the new filter entry.
    10. Point to Computer Update Status With Update Information, and then select Update Installation State (Friendly Name).
    11. Next to the new field name, click Select Operator, and then select does not equal.
    12. Next to the new operator, click Enter Value, and then select Enter Value.
    13. In the text box, enter Unknown.
  10. Click Next.
  11. In the Report Name field, enter a unique name. For example, enter Computers to Update.
  12. Select Save and run report now.
  13. Click Finish.

 

Last modified
01:04, 23 Jun 2016

Tags

Classifications

Public