OEM agent 12c - Need a report to show alerts that have been open for 4 hours or more
Hi,I see there is a canned report to show current open alerts, but is there a way to take that code and modify it somehow to report on alerts that have been open for 4 hours or more?
Here is the code from the report that is canned to show all current open alerts:
SELECT A.TARGET_NAME TARGET_NAME_ID,A.TYPE_DISPLAY_NAME TARGET_TYPE_ID,
A.METRIC_LABEL METRIC_GRP, A.COLUMN_LABEL METRIC_ID,decode(A.ALERT_STATE,'Critical',25,'Warning',20) SEVERITY_ID,
MGMT_VIEW_UTIL.ADJUST_TZ(A.COLLECTION_TIMESTAMP,B.TIMEZONE_REGION,??EMIP_BIND_TIMEZONE_REGION??) OPEN_SINCE_ID,
0