Viewed the Windows Compliance By Computer report; found extremely high Software Update count totals in Patch Management Solution 8.0, 8.0 HF1 and 8.0 HF2. Additionally, found drill-downs display conflicting counts to those displayed on the main report.
Highlighted affected Client in the returned data, right-click > View (View Applicable Updates, View Installed Updates, and View Not Installed Updates); found the numbers display accurately displays more accurate counts.
Appears the problem only occurs for Clients reporting a reboot is pending.
Confirmed the spPMWindows_ComplianceByComputer is utilizing a left join that is causing the results to render with all Software Updates until the Client is rebooted.
This issue has been resolved in 8.0 HF3 - See release notes for more information DOC9378
Implement the PointFix by working through the following steps in the SQL Server Management Studio:
Under Object Explorer: Expand the SQL instance > Symantec_CMDB > Programmability > Stored Procedures; right-click on this folder > Filter > Filter Settings, and input the following under Value: spPMWindows_ComplianceByComputer.
Highlight the Stored Procedure in the left pane; dbo.spPMWindows_ComplianceByComputer > right-click > rename, and add the .old extension as follows:
Copy the attached 'spPMWindows_ComplianceByComputer_Fix.sql' file to the SQL Server Management Studio; execute the SQL script to implement the updated Stored Procedure and should appear as follows:
The report should render using the updated Stored Procedure and the issue should be resolved.
Save and run on SQL Server Management Studio to Create the fixed Stored Procedure once the original is backed up per Solution detailed steps.