Custom Patch Report that shows which computers are Vulnerable, Installed, or Targeted by specific bulletins
book
Article ID: 171040
calendar_today
Updated On:
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.
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.
Attachments
Windows Patch Applicability for all computers, All bulletins.sqlget_app