Custom Patch Report that shows which computers are Vulnerable, Installed, or Targeted by specific bulletins
book
Article ID: 171040
calendar_today
Updated On:
Products
Patch Management Solution
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 and possibly other versions.
Resolution
Edit the attached SQL query to pick the Filter GUID and also the 'applicable', 'vulnerable', 'installed', and 'targeted' option. Query may be copied into a new SQL Report in the NS Console.
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.
Attachments
Windows Patch Applicability for all computers, All bulletins.sqlget_app