Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2167)

2130 Brocade Network Advisor SAN + IP User Manual
53-1002949-01
Database tables and fields
I
TABLE 278 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 279 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