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 > Generate a report

Generate a report

Created by Caroline Juszczak, last modified by Steve.Hawkins on Aug 02, 2018

Views: 1,066 Votes: 0 Revisions: 14

When you generate a Patch Manager report (such as a WSUS report), Report Viewer opens in a new window. Use Report Viewer to customize the report layout and filter and sort the report results. When you are finished, configure the report viewer email settings, and then export and email the report results to one or more users. 

Run WSUS reports

After you set up the WSUS inventory to query your upstream and downstream WSUS servers, you can review the server status using the WSUS reports. These reports provide information about your WSUS server performance and update packages installed on managed systems by the WSUS server.

The WSUS reports are located at Administration and Reporting > Reporting > WSUS reports.

SPM-Admin-Guide-Select-WSUS-Reports.png

Windows Server Update Services reports

These WSUS reports provide high-level information about update packages installed on the managed systems by the WSUS server. This information includes the installation percentage for each update.

Below is a list of common Windows Server Update Services reports.

Report Name Description
Computers with approved update percentages Reports the percentage of systems running approved updates.
Percent Failed Reports the percentage of update packages that failed to install during the update.
Percent Installed Reports the percentage of update packages that installed during the update.
Percent Not Installed Reports the percentage of uninstalled update packages.
Update Approvals Reports the update title, computer group name, release date, and administrator for each approved update.

Windows Server Update Services Analytics reports

These WSUS reports detailed information about update packages installed on the managed systems by the WSUS server. This information includes the update state for each update and computer.

Below is a list of Windows Server Update Services Analytics reports you can use in your deployment.

Report Name Description
Computer Update Status Reports all Microsoft and third-party updates to each managed system and whether they are approved, installed, or failed. This report does not explain why an update failed.
Computer Update Status Approved Updates Reports the approved upgrade packages and whether they are installed or not installed.
Computer Update Status Approved Updates Not Installed Reports the approved upgrade packages that were not installed. This report does not state whether the upgrade was applicable for each system.

Windows Server Update reports

These WSUS reports provide information about the Windows Update Agent. This agent runs on the managed computers and checks the WSUS server for the latest published updates.

Run a WSUS report

  1. Log in to the Patch Manager Administrator Console.
  2. In the navigation pane, expand Administration and Reporting > Reporting > WSUS Reports.
    SPM-Admin-Guide-WSUS-Reports-Navigation.png
  3. Select a report category.
    For example, Windows Server Update Services Analytics.
  4. In the center pane, select a report.
  5. In the Actions pane, click Run Report. 

Customize report layouts

You can customize how the information is displayed in the report. Any change you make to a report layout displays in all reports. 

The following table lists the procedures for customizing a report layout.

Task  Procedure
Increase the number of lines Report Viewer displays per page Click Navigation Configuration, and then enter a value up to 100,000. The default value is 2,000.
Reorganize the columns in the report

Drag and drop any column to a new position.

For example, drag the Domain or Workgroup (Update Server) and Name (Update Server) columns to the far right of the data grid.

Resize the columns Reposition the column separators in the header row.
Group results by the values in a column

Drag the column header into the group bar.

For example, drag Computer Name into the group bar, as shown below.

03000005_480x113.png

Show or hide available columns
  1. Click Column Chooser.
  2. Select the columns you want to show.
  3. Clear the columns you want to hide.
  4. Close the Column Chooser window. 
Save a custom layout Click Save Layout. 

Filter and sort report results

You can sort the report list by the clicking the sort icons in each column. This sorts the entire report list by the contents of the selected column. You can sort each column in either ascending or descending order.

Task Procedure
Filter report results
  1. Click File:Success_Center/New_Articles/PatchManager_Admin_Guide_MT/060/070/03000006.png in any column to expose the filter options for that column.
  2. Clear or select values as appropriate.
  3. Click OK.
Sort a report by the values in a specific column

Click the column header once to sort in ascending (A-Z) order.

Click the column header twice  to sort in descending (Z-A) order.

Configure the Report Viewer email settings

To configure email settings for Report Viewer:

  1. In the Report Viewer window, click Email Configuration.
    SPM-Admin-Guide-Email-Configuration.png
  2. Complete the options in the Console Email Settings dialog box.
    SPM-Admin-Guide-Console-Email-Settings.png
    1. Enter the SMTP Server and Sender Email Address (required).
    2. If your email server uses a custom port, modify the Port value as appropriate.
    3. If your email server uses a secure connection, select Use SSL or Use TLS.
    4. If you want to specify one or more favorite recipients, enter the email address(es) in the Favorite Recipients field. Separate two or more addresses with semicolons.
  3. Click OK. 

Export and email the report results

  1. In the Report Viewer window, click Email.

    SPM-Admin-Guide-Report-Viewer-Email.png

  2. Complete the Email Recipients dialog box.
    SPM-Admin-Guide-Email-Recipients-Dialog-Box.png
    1. In the Recipient field, enter at least one email address. 
    2. (Optional) Enter a description.
    3. Click Add.
    4. Click OK.
  3. In the Export Options window, select the format you want to use for your report.
  4. In the Export Filename field, browse to or enter a custom path/filename, or accept the default.
  5. Click Export.
Last modified

Tags

Classifications

Public