Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Patch Manager > Patch Manager Documentation > Patch Manager 2.1.5 Administrator Guide > Configure the inventory tasks and generate reports > Customize an existing Patch Manager report

Customize an existing Patch Manager report

Table of contents
No headers
Created by Caroline Juszczak, last modified by Steve.Hawkins on Feb 16, 2018

Views: 971 Votes: 0 Revisions: 9

Use the Report Definition Builder to customize existing Patch Manager reports and refine or expand the results. The following example describes how to customize a Computer Update Status report to only include updates that are required but not installed.

  1. Log in to the Patch Manager Admin Console.
  2. In the navigation pane, expand Administration and Reporting > Reporting > WSUS Reports.
    SPM-Admin-Guide-WSUS-Reports-Navigation.png
  3. Select Windows Server Update Services Analytics.
  4. In the center pane, select Computer Update Status.
  5. In the Actions pane, click Edit and Schedule Report.
    SPM-Admin-Guide-Reporting-Computer-Update-Status1.png
  6. Using the horizontal bar in each field, drag the Domain or Workgroup (Update Server) and Name (Update Server) fields to the bottom of the list.
    SPM-Admin-Guide-Reporting-Computer-Update-Status2.png
  7. Drag Computer Name to the top of the list.
    SPM-Admin-Guide-Reporting-Computer-Update-Status3.png
  8. Set the report to sort by the Computer Name column.
    Click Not Sorted next to the column name.
  9. Add the Update ID field to the report:
    1. Click [+] at the bottom of the first column, adding a new field.
    2. Click Select Field and select Computer Update Status > Update ID.
      SPM-Admin-Guide-Reporting-Computer-Update-Status4.png
  10. Add a filter to the report for updates to install upon approval.
    SPM-Admin-Guide-Reporting-Computer-Update-Status5.png
    1. Click [+] under Select the filter criteria for the report.
    2. Click Select Field and select Computer Update Status > Update Approval Action (Friendly Name).
    3. Click Select Operator and select equals.
    4. Click <Enter Value> and select Enter Value.
    5. In the text box, enter Install and press <Enter>.
  11. Add a filter to the report for updates with states that are not Installed or Unknown.
    SPM-Admin-Guide-Reporting-Computer-Update-Status6.png
    1. Click [+] next to the existing filter.
    2. Click Select Field for the new filter entry.
    3. Click Select Operator and select does not equal.
    4. Click <Enter Value> and select Enter Value.
    5. In the text box, enter Installed and press <Enter>.
    6. Click the arrow next to Update Installation State (Friendly Name) and select Place in New Group.
    7. Click [+] and then click Select Field.
    8. Click Select Field and select Computer Update Status &gt; Update Installation State (Friendly Name).
    9. Click Select Operator and select does not equal.
    10. Click <Enter Value>, and then select Enter Value.
    11. In the text box, enter Unknown and press <Enter>.
  12. Click Next.
  13. In the Report Name field, enter a unique name.
    For example, enter Computer Updates – Approved Not Installed.
    SPM-Admin-Guide-Reporting-Computer-Update-Status7.png
  14. Click Save and run report now, and then click Finish.
  15. Examine your report and customize the layout (if required).
    See Using Patch Manager Report Viewer for details.
Last modified

Tags

Classifications

Public