Generate a custom report

Use the Report Definition Builder to generate custom SolarWinds Patch Manager reports. You can generate a custom WSUS report with 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.

This section describes how to:

Before you begin

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.

When you generate a custom report, be sure to select only the fields you need for the report. Otherwise, Patch Manager will continuously peg the database, allowing the tempdb file to grow until your drive space reaches maximum capacity. If this issue occurs, restart the SQL Server service to reclaim the space.

Generate a custom WSUS report

The following procedure describes how to create a custom WSUS report. This example describes how to customize a report to list and automatically install updates directly from the Report Viewer.

  1. In the navigation menu, expand Administration and Reporting > Reporting > WSUS Reports.

  2. Select Windows Server Update Services Analytics.
  3. In the Reports pane, select the report you want to create.
  4. In the Actions Pane, click New Report.
  5. In the Report Definition Builder window, select the fields you want to include in the report.
  6. Select the column and sort order for your fields.
  7. Apply any filters you want to save in your report, and then click Next.
  8. Name the report.
  9. Specify any scheduling preferences, and then click Finish.

Install updates from a WSUS report

After you create a custom WSUS report, complete the following procedure to install updates directly from Report Viewer.

  1. Run a report that returns the Update ID and Update Revision Number columns.
  2. In the Report Viewer window, select the update(s) you want to install.
  3. Click the Actions tab.
  4. Click Update Management.
  5. In the Update Management window, click OK.
  6. In the Task Options Wizard window, add the computers that receive the updates, and click Next.
  7. Complete the Scheduling and Notification Options form, and then click Next.
  8. 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:
    • Computer Name
    • Update Title
    • Update Installation State (Friendly Name)
    • Update ID
    • Update Revision Number
    • 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.

Create a custom report that lists the third-party software installed on client systems

  1. Log in to the Patch Manager Administrator Console.
  2. In the navigation pane, expand Administration and Reporting > Reporting > Configuration Management Reports and select Installed Programs and Features.
  3. In the center pane, select Installed Programs and Feature Basic (MS Product Omitted).
  4. In the Actions pane, click New Report.
  5. Define the report fields.
    1. Click + and then click Select Field.
    2. Mouse over Programs and Features.
    3. Select Name (Programs and Features).
  6. Repeat step 5 to define the display name.
  7. Click Next.
  8. Add a name to the report.
  9. Click Save and run report now.

You can sort the data using the columns headers at the top, and add additional fields and filters to increase the amount of generated information.