User's Manual

Brocade Network Advisor IP User Manual 1445
53-1003056-01
Database tables and fields
I
TOTAL_OUTPUT_POWER provides the total power output of the power supply FRU
element, requested by SMIA and values filled in by
Switch Asset Collector will be available only from FOS
6.4 switches and above. this field is applicable only for
the power supply FRU element. The default value is -1.
bigint
SPEED provides the speed of the FAN FRU element, requested
by SMIA and values filled in by Switch Asset Collector
will be available only from FOS 6.4 switches and above.
this field is applicable only for the FAN FRU element.
The default value is -1.
int
CREATION_TIME provides the record creation time, standard columns for
Management application and values filled in by Switch
Asset Collector
timestamp
LAST_UPDATE_TIME provides the record creation time, standard columns for
Management application 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 157 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 the
Management application 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 512
ROOT_DIRECTORY FTP server root directory location. varchar 1024
PORT Port on which FTP server is configured. int
TABLE 158 GENERATED_REPORT
Field Definition Format Size
ID* int
NAME Report name. varchar 256
TYPE_ID Report type. int
TABLE 156 FRU (Continued)
Field Definition Format Size