beautypg.com

Brocade Network Advisor SAN + IP User Manual v12.3.0 User Manual

Page 2407

background image

Brocade Network Advisor SAN + IP User Manual

2335

53-1003155-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 160

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 161

GENERATED_REPORT

Field

Definition

Format

Size

ID*

int

NAME

Report name.

varchar

256

TYPE_ID

Report type.

int

TABLE 159

FRU (Continued)

Field

Definition

Format

Size