"Monitored Resources by Status" web part not updating properly

Article:TECH160978  |  Created: 2011-05-26  |  Updated: 2012-03-26  |  Article URL http://www.symantec.com/docs/TECH160978
Article Type
Technical Solution


Issue



One an alert has been resolved for a resource, the resource is still being displayed as having a Critical, Major, or Warning status in the Monitored Resources by Status web part.

 


Environment



  • Monitor Solution for Servers 7.1.7113
  • Monitor Solution for Servers SP1  7.1.7348

 


Cause



This behavior may occur if a user chose the Acknowledge action for any of the triggered alerts followed by a Resolve action for those same alerts. These combined actions cause a SQL stored procedure and view to result in incorrect data.

This is a known issue and has been submitted to development.

 


Solution



This issue is resolved in the 7.1 SP2 release of Monitor Solution for Servers.

  

Workaround

  1. In Microsoft SQL Server Management Studio, create a backup of the vEventConsoleStatusRollUp view and _sp_ec_get_device_health_global_rollup_by_target_and_product stored procedure
      
  2. Attached to this article are 2 SQL scripts, vEventConsoleStatusRollUp.sql and _sp_ec_get_device_health_global_rollup_by_target_and_product.sql. Run each of these scripts against the CMDB to revise the effected stored procedure and view

   


Supplemental Materials

SourceETrack
Value2385954
Description

 "Monitored Resources by Status" web part does not display correct data after Acknowledge then Resolve for an alert



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


Terms of use for this information are found in Legal Notices