zz$gauge alert

From zzat
Jump to: navigation, search

zz$gauge_alert tracks the alerts that the gauges are producing.

It has the following columns:

Column Name Data Type Description
zz$db number Database DBID from zz$db that produced the alert.
name varchar2 Name of the gauge the produced the alert.
col# number Refers to the column number in zz$gauge_cols.col# that produced the alert.
snap# number Snapshot number from zz$snap which produced the alert.
run# number Unique identifier of the gauge run that produced the alert. References zz$gauge_runs.run#
action# number The task ID of the gauge run that produced the alert. Refers to the action# in zz$sync_staging or zz$sync_state.
type# number Type of the alert. 0=warning, 1=critical.
override_name varchar2 If applicable, the name of the override that produced the alert.
infovalue_num number The value of the informational column as defined in the gauge, if numeric.
infovalue_varchar varchar2 The value of the informational column as defined in the gauge, if it's a string.
infovalue_date date The value of the informational column as defined in the gauge, if it's a date.
rowvalue_num number The offending value that triggered the alert, if numeric.
rowvalue_varchar varchar2 The offending value that triggered the alert, if it's a string.
rowvalue_date date The offending value that triggered the alert, if it's a date.
alert_created timestamp Timestamp in UTC when the alert entry was created by the gauge.
alert_triggered timestamp Timestamp in UTC when the alert was triggered by the reaction.
alert_acknowledged timestamp Timestamp in UTC when the alert was acknowledged.
flags number Used to mark special attributes of the alert. Currently this only has a value if the alert was automatically acknowledged as part of zztat's automatic redundant alert elimination.