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


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:

  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


Article URL

Terms of use for this information are found in Legal Notices