Enterprise Manager Generic (MOSC)

MOSC Banner

Metric Extensions (SQL based) - How to include information from other columns in alert message

edited Jun 19, 2013 10:25PM in Enterprise Manager Generic (MOSC) 1 commentAnswered
To make the alert message more informative, I'd like to add more information from other columns of the sql I've created.

This document describes how to create a sql base metric extension:

https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_afrLoop=650687951413279&_afrWindowMode=0&_adf.ctrl-state=kfddizeei_4

But this only includes two columns, tablespace_name and free space. Tablespace_name is defined as Key Column and free space as data column (named Free_percentage).

The alert message is defined as: "The value of %columnName% for %keyValue% is %value%.

What I want to do is to add another column or more to my sql, and include this in the alert message. To achieve this I would Add Column to

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