User guide

ExtremeWare EPICenter Software Installation and User Guide C-7

Database Alarm Log View

Table C-4: EPICenter Database Alarm Log View

Alarm_Log_View

Alarm_Log_View is a database view that shows the EPICenter alarm log, but making the data

from each column into a human readable format.

Column Name

Column

Type Description

alarm_time integer The time when the event happened. This time is

shown as milliseconds since 1970-01-01 00:00:00

GMT. This time is unique for all alarm logs. (This

column can be used as the primary key.)

alarm_name string The name of the alarm definition, to which this alarm

instance belongs.

alarm_category string The alarm category as defined in the alarm definition.

source string The IP (and the ifIndex, if appropriate) of the source,

from which the event that triggered the alarm is

generated. E.g. “10.205.0.31”, “10.205.0.31, port 2:1”,

or “10.205.0.2, ifIndex 10”.

severity string The severity of the alarm as defined in the alarm

definition.

msg string The alarm message as defined in the alarm definition.

acked byte A byte value in hexadecimal representation specifying

whether the alarm is ack’ed or not, 00 – not ack’ed; 01

– ack’ed.

event_log_id integer The event log id of the event that triggers the alarm.

unsignedIPInt integer The IP address number of the device, from which the

event that triggers the alarm originates. This is the

same IP address as in the event_ip column, except

thatthe address is represented using a unsigned 32-bit

integer: e.g. the IP Address “10.205.0.1” is

represented as 181207041.