Brocade Communications Systems IP250 Database tables and fields Mapsevent, Mapseventdetails

I Database tables and fields

TABLE 226 MAPS_EVENT (Continued)

Field	Definition	Format	Size
SWITCH_PORT_ID	Nullable foreign key. The FC port for which the event	int
	occurred. This will only be populated for port events.
FCIP_CIRCUIT_ID	Nullable foreign key. The FCIP tunnel circuit for which	int
	the event occurred. This will only be populated for FCIP
	tunnel events.
FRU_NAME	For switch policy status events, the object name is	varchar	32
	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.
VM_ID	Nullable foreign key. The VM for which the event	int
	occurred. This will only be populated for vCenter
	events.
FLOW_DEFINITION_ID	Nullable foreign key. The NP flow definition for which	int
	the event occurred. This will only be populated for flow
	events
INTERFACE_ID	Denotes interface_id for NOS interface related interface	int
	violations. This will only be populated for NOS Ethernet
	related port Events, for other FC ports of NOS
	switch_port_id will be populated.

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	int
	- Hour, 3 - Day
ACTIONS	A bit map for the actions configured for the rule. 0 -	int
	None, 1 - RASLOG, 2 - SNMP, 4 - Email, 8 - Fence Port,
	16 - SW_ST_DOWN, 32 - SW_ST_MARGINAL.
CURRENT_VALUE	The current value of the measure that triggered the	varchar	32
	violation.
SWITCH_ENABLED_ACTI	MAPS actions enabled on the switch at the time the	int
ONS	violation occurred.

TABLE 228 MAPS_EVENT_CAUSE_ACTION

Field	Definition	Format	Size
VIOLATION_TYPE	The type of the violation. i.e. CRC, ITW, as defined in	int
	MapsConstants.
ACTION	Description of the recommended action for the MAPS	varchar	4096
	violation.

1478	Brocade Network Advisor IP User Manual
	53-1003056-01