Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Patch Manager > Patch Manager 2.1.5 Administrator Guide > Inventory and Reporting > Creating a Custom Report

Creating a Custom Report

Created by Caroline Juszczak, last modified by Caroline Juszczak on Mar 22, 2017

Views: 102 Votes: 0 Revisions: 5

Use the Report Definition Builder to create custom Patch Manager reports. Use the following example 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. This section addresses the following procedures:

Creating a Custom WSUS Report

The following procedure presents an example of how to create a custom WSUS report. The report in this example is configured to allow you to install updates directly from Report Viewer.

To create a custom 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. 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.
  14. Examine your report and customize the layout as needed. For additional information, see "Using Patch Manager Report Viewer".

Installing Updates from a WSUS Report

Complete the following procedure to install updates directly from Report Viewer. In order for this to work, the report must be configured to pull specific data. For additional information, see "Creating a Custom WSUS Report".

To install an update from a WSUS report:

  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. On the Update Management window, click OK.
  6. On the Task Options Wizard window, add the computers on which to install the updates.
  7. Click Next.
  8. Complete the Scheduling and Notification Options form, and then click Next.
  9. Click Finish.
Last modified
11:31, 22 Mar 2017

Tags

Classifications

Public