ITMS 8.0 and 8.1 Report pack to view Superseded Updates compliance

book

Article ID: 179085

calendar_today

Updated On:

Products

Patch Management Solution for Windows

Issue/Introduction

Resolution

Note: This reports will not work in version 8.5 as we introduced new report functionality to view all bulletins including those that are superseded, or just bulletins were one or more updates are not superseded using drop-down parameters at the top of the Software Bulletin Details and Compliance reports for Patch Management.

Work through the following process for implementing an updated Compliance Report Pack to display a drop-down option for reviewing compliance on Superseded Software Updates in ITMS 8.0 or 8.1:

Ensure recent backup of the database was executed.
Download the attached superseded_compliance_reports.zip.
Extract contents to any computer with access/rights to view the Console and SQL Server Management Studio (SMS).
Open each individual spPMWindows_...sql file; should populate in SQL SMS, and execute against the Symantec_CMDB (default name) database.
Open the Console > Reports > Software > Patch Management > Compliance.
Right-click on Compliance folder > Import > Browse (select saved location of Superseded.xml within the superseded_compliance_reports folder).
The report folder Superseded should be present under that Console location and the drop-down to view All (adds Superseded Updates to Compliance Review) or Non-Superseded (same as canned reports):

Advisory: With the release of PMImport 7.2.x; Patch Management is able to target most Superseded Updates for deployment as long as they are present in the Patch Remediation Center.

Enhancement Request: Add this functionality in canned Compliance Reports is currently under review by Symantec Corp. Subscribe to this article to receive email notifications when it has been updated.