Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1226 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
CREATION_TIME provides the record creation time, standard columns for
Management applciation and values filled in by Switch
Asset Collector
timestamp
LAST_UPDATE_TIME provides the record creation time, standard columns for
Management applciation and values filled in by Switch
Asset Collector
timestamp
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 144 FTP_SERVER
Field Definition Format Size
ID* int
TYPE Type indicates the what type of file. Internal FTP - 0,
External FTP - 1, External SCP - 2, Internal SCP/SFTP -
3, External SFTP - 4 and Technical support FTP - 100.
Technical Support FTP server configuration is created
by user to transfer the technical support files from BNA
repository to specified FTP server. Other server
configurations can be seen in Options dialog.
smallint
IP FTP server IP address. varchar 64
USER_NAME FTP server user name. varchar 64
PASSWORD FTP server user password. varchar 64
ROOT_DIRECTORY FTP server root directory location. varchar 1024
PORT Port on which FTP server is configured. int
TABLE 145 GBIT_ETHERNET_INTERFACE
Field Definition Format Size
INTERFACE_ID int
TABLE 146 GIGE_PORT
Field Definition Format Size
ID* Unique generated database identifier. int
SWITCH_PORT_ID ID for the GigE Port in SWITCH_PORT. int
PORT_NUMBER GigE Port Number(0 for ge0 and 1 for ge1). int
SLOT_NUMBER Slot number on which the GigE Port is present. int
ENABLED Enabled or disabled.
Default value is 0.
smallint
SPEED Port speed details.
Default value is 0.
bigint
TABLE 143 FRU (Continued)
Field Definition Format Size