Security Compliance

Create a third-party updates report in Patch Manager

This article describes how to create a Patch Manager report that only displays third-party updates.

First published date

10/26/2018 8:45 PM

Last published date

10/26/2018 8:45 PM

Overview

The Update Source field in WSUS inventory reports shows whether the update is a Microsoft or third-party update. Use this field to filter for only third-party updates.

Product section

Patch Manager

Resolution

You can download the report from THWACK or create the report using the following instructions. 

Create a Patch Manager report for third-party updates 

  1. Log in to the Patch Manager Console as an administrator.
  2. In the navigation pane, expand Administration and Reporting > WSUS Reports and select Windows Server Update Services Analytics. 
  3. Click New Report in the Actions pane.
  4. Click + and then click Select Field.
  5. Select Computer Update Status With Update Information.
  6. Add the following fields in order:
    1. Computer Name
    2. Update Approval Action (Friendly Name)
    3. Update Installation State (Friendly Name)
    4. Domain or Workgroup (Update Server)
    5. Name (Update Server)
  7. Sort the Update Title field in ascending order.
  8. Click the Not Sorted button next to the Computer Name field and select Add to next sort position > Ascending.
  9. Select the Computer Update Status With Update Information field
  10. Add the Update Source field to the filter.
  11. Click Select Operator, and choose does not equal.
  12. Enter a value in Microsoft Update.
  13. Click Next.
  14. Enter the name of your report.
  15. Click Finish.

Filter a report by a specific column in Report Viewer 

  1. Click the filter icon in the column header to expose the filter options for that column.
  2. Clear or select values as appropriate. Report Viewer displays values with a checkmark next to them.
  3. Click OK.

For additional information about how to create custom reports, see How to create a custom report using Patch Manager Report Definition Builder.