Home > Success Center > Patch Manager > Patch Manager 2.1.4 Administrator Guide > Inventory and Reporting > Customizing a Patch Manager Report

Customizing a Patch Manager Report

Table of contents
No headers
Created by Caroline Juszczak, last modified by MindTouch on Jun 23, 2016

Views: 439 Votes: 0 Revisions: 6

Use the Report Definition Builder to customize existing Patch Manager reports to refine or expand the scope of their results. You can also customize certain layout options, such as the order in which the report displays its columns. Use the following example to customize the Computer Update Status report to show only updates that are needed, but not already installed.

To customize a WSUS report (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. To open Report Definition Builder, click Edit and Schedule Report in the Actions pane (right).

File:Success_Center/New_Articles/PatchManager_Admin_Guide_MT/060/080/03000007_374x268.png

  1. Using the [- ] at the far right, drag Doman or Workgroup (Update Server) and Name (Update Server) to the bottom of the list.
  2. Using the [ - ] at the far right, drag Computer Name to the top of the list.
  3. Set the report to sort by the Computer Name column:
    1. Click Not Sorted next to the column name.
    2. Point to Sort position 1, and then select Ascending.
  4. Add the Update ID field to the report:
    1. Click [+] to the left of the last column.
    2. Click Select Field for the new column entry.
    3. Point to Computer Update Status, and then select Update ID.
  5. Add a filter to the report for updates to 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, 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.
  6. 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, 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, 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.
  7. Click Next.
  8. In the Report Name field, enter a unique name. For example, enter Computer Updates Approved Not Installed.
  9. Select Save and run report now.
  10. Click Finish.
  11. Examine your report and customize the layout if you want. For additional information, see "Using Patch Manager Report Viewer".
You must to post a comment.
Last modified
07:10, 23 Jun 2016

Tags

Classifications

Public