Brocade Communications Systems IP250 Gigeport, Database tables and fields Generatedreport

I	Database tables and fields
		TABLE 158 GENERATED_REPORT (Continued)
		Field	Definition	Format	Size
		EFCM_USER	Management application user who has generated	varchar	128
			this report.
		REPORT_OBJECT	Report object BLOB.	bytea
		TIMESTAMP_	Timestamp when the report is generated.	timestamp
		FABRIC_NAME	Fabric Name.	varchar	256
		TABLE 159 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.	smallint
			Default value is 0.
		SPEED	Port speed details.	bigint
			Default value is 0.
		MAX_SPEED	Port maximum speed supported.	bigint
		MAC_ADDRESS	MAC Address of that port.	varchar	64
		PORT_NAME	GigE Port Name.	varchar	64
		OPERATIONAL_STATUS	LED status.	int
		LED_STATE	LED status.	smallint
		SPEED_LED_STATE	GigE Port type details.	smallint
		PORT_TYPE	Port type for the GigE Port.	varchar	64
		PERSISTENTLY_DISABLED	Whether the GigE Port is persistently disabled.	smallint
		INTERFACE_TYPE		smallint
		CHECKSUM		varchar	16
		FCIP_CAPABLE	1 = FCIP capable; otherwise, 0.	smallint
			Default value is 2.
		ISCSI_CAPABLE	1 = ISCSI capable; otherwise, 0.	smallint
			Default value is 2.
		REMOTE_MAC_ADDRESS	MAC address of attached port of the 10G GigE Port.	varchar	64
		INBAND_MANAGEMENT_ST	1 = Inband Management status is enabled;	smallint
		ATUS	otherwise, 0.
			Default value is 0.
		OCCUPIED	Default value is 0.	smallint
		LAST_UPDATE		bigint

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