Patch Management 6.2: Software Update Execution Summary report may display incorrect data
|Article:TECH28474|||||Created: 2007-04-05|||||Updated: 2009-11-01|||||Article URL http://www.symantec.com/docs/TECH28474|
On the Patch Management Dashboard, there are unusually high numbers returned by the Software Update Execution Summary report. When drilling down to view the number of computers, the number of rows returned is not consistent with what is displayed in the dashboard.
Patch Management Solution 6.2, 6.2 SP1
The SQL stored procedure used to determine these numbers is not filtering duplicate entries.
Download the new Stored Procedure attached to this article.
Instructions to update:
- Unzip the file to a convenient location.
- Open SQL Query Analyzer.
- Select the Altiris database.
- Copy and paste the contents of the .sql file into Query Analyzer.
- Execute the query.
KB46144 "Combined fixes for known Patch Report Discrepencies, Dashboard issues etc" also includes this fix and several more.
Article URL http://www.symantec.com/docs/TECH28474