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

Brocade Network Advisor SAN + IP User Manual 2083
53-1002949-01
Database tables and fields
I
TABLE 184 EVENT_CATEGORY
Field Definition Format Size
ID Unique generated database identifier. int
DESCRIPTION Holds the event categories. Possible values :
Unknown- 0, Product Event- 1, Link Incident Event- 2 ,
Product Audit Event- 3, Product Status Event- 4,
Security Event- 5 , User Action Event- 6, Management
Server Event- 7. varchar 50
TABLE 185 EVENT_DESCRIPTION
Field Definition Format Size
ID Unique generated database identifier. int
DESCRIPTION Holds the description of the Event. varchar 1024
TABLE 186 EVENT_DETAILS
Field Definition Format Size
ID Unique generated database identifier. int
EVENT_ID Database ID of the EVENT instance. int
FIRST_OCCURRENCE_SWI
TCH_TIME Indicates the first occurrence switch timestamp of the
event. timestamp
LAST_OCCURRENCE_SWIT
CH_TIME Indicates the last occurrence switch timestamp of the
event. timestamp
CONTRIBUTORS Indicates the contributing factor for the event resulted
due to a status change of the switch. varchar 512
OPERATIONAL_STATUS Indicates the operational Status of the product
associated with the event. varchar 255
NODE_WWN Unique World Wide Number for the product. varchar 23
PORT_WWN Unique World Wide Number for the port for which the
event was generated. varchar 23
OID Indicates the Object ID of the Trap or Syslog. varchar 50
VIRTUAL_FABRIC_ID Indicates the Virtual Fabric id of the switch which
triggered the event. smallint
UNIT Indicates the Unit number of the Chassis from which
the event was triggered. smallint
SLOT Indicates the blade or the slot number in which the
port is present. int
PORT indicates the switch port number for which the event
was generated. int
PRODUCT_ADDRESS Indicates the IP Address of the Product from which the
event is originated. varchar
RAS_LOG_ID Indicates the RASLOG Id of the RASLOG event. varchar 20
INTERFACE_TYPE Indicates the type of the interface – Possible Values:
Ethernet Port-0, FC Port-1. smallint