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

Article Id: 171040
Status: Published
Updated On: 02-03-2018 07:16
Legacy Id: TECH249319
Products:
Management Platform (Formerly known as Notification Server)
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.

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.

insert_drive_file Windows Patch Applicability for all computers, All bulletins.sql
arrow_downward Download