Custom Patch Report that shows which computers that are Vulnerable, Installed, or Targeted by specific bulletins

Products

• Patch Management Solution
• IT Management Suite

Issue/Introduction

Is there a report that shows all systems that are Vulnerable, Installed, Targeted, or Applicable to ALL systems or a group of Computers?

Environment

ITMS 8.x

Patch Management 8.x

Resolution

There is an attached SQL query that can be edited to pick the Filter GUID and also the 'Applicable', 'Vulnerable', 'Installed', and 'Targeted' options.  The query may be copied into a new SQL Report in the NS Console by doing the following:

• Go to Reports> All reports
• Right Click on the Report > New > Report> SQL Report
• Delete the SQL code in the 'Parameterized Query' tab and replace it with the SQL in the article .
• Press Save Changes. 

NOTE: The attached query is AS-IS and is not supported by Broadcom Support.