User's Manual

1478 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
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
INTERFACE_ID Denotes interface_id for NOS interface related interface
violations. This will only be populated for NOS Ethernet
related port Events, for other FC ports of NOS
switch_port_id will be populated.
int
TABLE 227 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
TABLE 228 MAPS_EVENT_CAUSE_ACTION
Field Definition Format Size
VIOLATION_TYPE The type of the violation. i.e. CRC, ITW, as defined in
MapsConstants.
int
ACTION Description of the recommended action for the MAPS
violation.
varchar 4096
TABLE 226 MAPS_EVENT (Continued)
Field Definition Format Size