Enterprise Manager Generic (MOSC)

MOSC Banner

OEM agent 12c - Need a report to show alerts that have been open for 4 hours or more

edited Oct 7, 2013 8:13AM in Enterprise Manager Generic (MOSC) 9 commentsAnswered
 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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center