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

Products

• Patch Management Solution

Issue/Introduction

Customers are asking if we have 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, and possibly other versions.

Resolution

Edit the attached SQL query to pick the Filter GUID and also the 'applicable', 'vulnerable', 'installed', 'targeted' option.  Query may be copied into a new SQL Report in the NS Console.