Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

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

Create a custom Windows Server Update Services (WSUS) report

Created by Jason Dee, last modified by Randall Harwood on Jun 23, 2017

Views: 6,098 Votes: 0 Revisions: 10

Overview

This article provides brief information and steps to create custom Patch Manager reports using the Report Definition Builder. Create a Windows Server Update Services (WSUS) report that shows 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.

Note: In order for a Patch Manager report to return data for your managed computers, you must have scheduled and run at least one inventory task for the computers from which you want to collect information. For additional information about how to schedule inventory tasks in Patch Manager, see the Schedule inventory tasks to populate empty reports article.

Environment

All Patch Manager versions

Steps

Create a custom WSUS report

Note: The following procedure shows how to select and order fields prior to clicking the New Report button.

  1. Open the Patch Manager console, and expand the WSUS Reports node. 
  2. Select the type of report you want to create. 
  3. From the Actions pane, click 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, and then click Next.
  7. Name the report.
  8. Specify any Scheduling preferences, and then click Finish. 

 

Create a custom report that shows all Pending Updates

  1. Open the Patch Manager console and expand Administration and Reporting > Reporting > WSUS Reports.
  2. Select Windows Server Update Services Analytics.
  3. Select Computer Update Status in the middle pane. 
  4. From the Available Datasources tab, select Computer Update Status With Update Information.
  5. 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)
  6. From the Actions pane, click New Report.
  7. 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. 
  8. Add a filter to the report for updates that will install upon approval:
    1. Select the filter criteria for the report and expand it. 
    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
  9. 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 the 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.
  10. Click Next.
  11. Enter a unique name in the Report Name field. For example, Computers to update. 
  12. Select Save and run report now. 
  13. Click Finish.

 

 

Last modified
15:33, 23 Jun 2017

Tags

Classifications

Public