Brocade Communications Systems IP250 Ftpserver, Database tables and fields FRU, Generatedreport

	Database tables and fields		I
TABLE 156 FRU (Continued)
Field	Definition	Format	Size
TOTAL_OUTPUT_POWER	provides the total power output of the power supply FRU	bigint
	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.
SPEED	provides the speed of the FAN FRU element, requested	int
	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.
CREATION_TIME	provides the record creation time, standard columns for	timestamp
	Management application and values filled in by Switch
	Asset Collector
LAST_UPDATE_TIME	provides the record creation time, standard columns for	timestamp
	Management application and values filled in by Switch
	Asset Collector
PREVIOUS_OP_STATUS	provides the previous operational status of FRU	int
	element, requested by SMIA and values filled in by
	Switch Asset Collector. Helps identify the operational
	status transitions. The default value is -1.
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,	smallint
	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.
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

Brocade Network Advisor IP User Manual	1445
53-1003056-01