How to Delete Grid Control Alerts

Log onto the OMS database with  SYSMAN user.

Run SELECT TARGET_GUID,METRIC_GUID ,KEY_VALUE FROM MGMT_CURRENT_SEVERITY

This will display alerts on EM browser window.  Execute the below Package to delete the Alerts.

exec EM_SEVERITY.delete_current_severity(TARGET_GUID,

METRIC_GUID,KEY_VALUE);

Example:
exec EM_SEVERITY.delete_current_severity(‘……’,'….’,'SYS’);

Use the following SQL to generate delete Alert script for all Alerts for a Target.

select.target_name,
t.target_type ,
collection_timestamp ,
MESSAGE ,
‘execem_severity.delete_current_severity(”’
|| t.target_guid || ”’,”’
|| metric_guid || ”’,”’ ||
key_value || ”’)’
em_severity

FROM mgmt_targets t, mgmt_current_severity s
t.target_guid = s.target_guid
WHERE target_name LIKE
‘….’