Clearing Alerts
Jump to navigation
Jump to search
SELECT 'execute em_severity.delete_current_severity(p_target_guid =>'''||sev.target_guid||''', p_metric_guid =>'''||sev.metric_guid||''' , p_key_value =>'''||key_value||''');' AS command FROM MGMT_TARGETS tgt , MGMT_CURRENT_SEVERITY sev WHERE tgt.TARGET_NAME like '%&TGT_NAME%';
For older severities, just a straight delete from MGMT_SEVERITY table will do the trick!