Imported Document ID: TECH218446

Modified version of the Stored Procedure called when rendering the Compliance by Update report for Patch Management Solution in the Console. Work through the following to view this custom report: 1. Run the attached 'spPMWindows_ComplianceByUpdate2.sql' stored procedure in the SQL Server Management Studio, logged in with Application Identity Service Account Creds, against the Symantec_CMDB database. 2. Clone the 'Compliance By Update' report in the Console. 3. Select 'Edit' and modify the Parameterized Query tab: 'exec spPMWindows_ComplianceByUpdate2' for the updated Stored Procedure to be called. 4. Save Changes. The modified-cloned 'Compliance by Update' report reflects Severity by individual applicable Software Updates.

Thanks for your feedback. Let us know if you have additional comments below. (requires login)