Friday, September 27, 2013

Enterprise Manager -- Clear warnings appearing on dashboard..

Sometimes, Enterprise Manager alerts can be annoying... Fixing the problems that generate these alerts , actually does not clear these alerts...

Here is the way to clear these events from backend...

Run the following query and execute the output of the query with sysman..

select  'exec em_severity.delete_current_severity(''' ||
t.target_guid || ''',''' ||
metric_guid || ''',''' ||
key_value || ''')' em_severity
from sysman.mgmt_targets t
inner join
sysman.mgmt_current_severity s
on
t.target_guid = s.target_guid;


For example:

exec sysman.em_severity.delete_current_severity('....','....','.....','.....')..

No comments :

Post a Comment

If you will ask a question, please don't comment here..

For your questions, please create an issue into my forum.

Forum Link: http://ermanarslan.blogspot.com.tr/p/forum.html

Register and create an issue in the related category.
I will support you from there.