Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

1106 Brocade Network Advisor SAN User Manual
53-1002167-01
Database tables and fields
E
PREVIOUS_OP_STATUS provides the previous operational status of FRU
element, requested by SMIA and values filled in by
Switch Asset Collector. Helps identify the operational
status transitions. The default value is -1.
int
VENDOR This holds the vendor name information for FRU varchar 256
TABLE 322 GIGE_PORT_ETHERNET_CLOUD_LINK
Field Definition Format Size
ID int
CLOUD_ID int
SWITCH_PORT_ID The unique id of the switch TE port that this member
connects to.
int
TRUSTED smallint
CREATION_TIME timestamp
MISSING smallint
MISSING_TIME timestamp
TABLE 323 HBA
Field Definition Format Size
ID int
HOST_ID Primary key. int
NAME User defined name of the HBA varchar 128
POWER_MODE Power mode of the HBA varchar 256
MODEL Model code of the HBA varchar 256
MODEL_DESCRIPTION Model description for the HBA varchar 256
OPERATING_STATUS Current operating status of the HBA:
1: Enabled/0: Disabled.
The default value is 0.
smallint
CHIP_REVISION Revision level of the chip used in the
HBA
varchar 64
HARDWARE_PATH varchar 256
SERIAL_NUMBER Serial number of the HBA varchar 64
TEMPERATURE Temperatur of HBA. Both in
Celsius/Fahrenheit
varchar 16
USERNAME varchar 256
PASSWORD varchar 256
MANAGEMENT_STATE Management state bit mask,
Managed/Auth failed etc.
The default value is -1.
int
TABLE 321 FRU (Continued)
Field Definition Format Size