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.