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
Article Type
Technical Solution


Issue



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.


Environment



Patch Management Solution 6.2, 6.2 SP1

Cause



The SQL stored procedure used to determine these numbers is not filtering duplicate entries.

Solution



Download the new Stored Procedure attached to this article.

Instructions to update:

  1. Unzip the file to a convenient location.
  2. Open SQL Query Analyzer.
  3. Select the Altiris database.
  4. Copy and paste the contents of the .sql file into Query Analyzer.
  5. Execute the query.

KB46144 "Combined fixes for known Patch Report Discrepencies, Dashboard issues etc" also includes this fix and several more.


Legacy ID



34179


Article URL http://www.symantec.com/docs/TECH28474


Terms of use for this information are found in Legal Notices