Brocade Network Advisor SAN User Manual v12.1.0 User Manual
Page 1469
1422
Brocade Network Advisor SAN User Manual
53-1002948-01
Database tables and fields
H
TABLE 196
MAPS_EVENT
Field
Definition
Format
Size
ID
The primary key of the table.
int
HOST_TIME
The time at which the server processed the event.
timestamp
CATEGORY
The violations category. i.e. Port Health, Fabric Health,
etc.
int
VIOLATION_TYPE
The type of the violation. i.e. CRC, ITW.
int
MANAGED_ELEMENT_ID The managed element corresponding to this event.
int
ORIGIN_FABRIC_ID
The fabric from which the event originated. Retaining
this id as historical data.
int
SWITCH_PORT_ID
Nullable foreign key. The FC port for which the event
occurred. This will only be populated for port events.
int
FCIP_CIRCUIT_ID
Nullable foreign key. The FCIP tunnel circuit for which
the event occurred. This will only be populated for FCIP
tunnel events.
int
FRU_NAME
For switch policy status events, the object name is
provided in the event and indicates the name of the
FRU affected. i.e. PS 1, Fan 2. As this FRU object name
is only provided for one category of events, making the
column nullable.
varchar
32
VM_ID
Nullable foreign key. The VM for which the event
occurred. This will only be populated for vCenter
events.
int
FLOW_DEFINITION_ID
Nullable foreign key. The NP flow definition for which
the event occurred. This will only be populated for flow
events
int
TABLE 197
MAPS_EVENT_DETAILS
Field
Definition
Format
Size
ID
The primary key of the table.
int
MAPS_EVENT_ID
The corresponding maps_event.
int
SWITCH_TIME
The switch timestamp from the event.
timestamp
RULE_NAME
The name of the threshold rule.
varchar
32
RULE_CONDITION
The threshold condition in string format. i.e. CRC > 30
varchar
128
TIME_BASE
The time base for the threshold. 0 - None, 1 - Minute, 2
- Hour, 3 - Day
int
ACTIONS
A bit map for the actions configured for the rule. 0 -
None, 1 - RASLOG, 2 - SNMP, 4 - Email, 8 - Fence Port,
16 - SW_ST_DOWN, 32 - SW_ST_MARGINAL.
int
CURRENT_VALUE
The current value of the measure that triggered the
violation.
varchar
32
SWITCH_ENABLED_ACTI
ONS
MAPS actions enabled on the switch at the time the
violation occurred.
int