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

Page 2140

Advertising
background image

Brocade Network Advisor SAN + IP User Manual

2103

53-1002949-01

Database tables and fields

I

SPEED

Port speed details.
Default value is 0.

bigint

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.
Default value is 2.

smallint

ISCSI_CAPABLE

1 = ISCSI capable; otherwise, 0.
Default value is 2.

smallint

REMOTE_MAC_ADDRESS

MAC address of attached port of the 10G GigE Port.

varchar

64

INBAND_MANAGEMENT_ST
ATUS

1 = Inband Management status is enabled;
otherwise, 0.
Default value is 0.

smallint

OCCUPIED

Default value is 0.

smallint

LAST_UPDATE

bigint

TABLE 222

GIGE_PORT_ETHERNET_CLOUD_LINK

Field

Definition

Format

Size

ID

Unique generated database identifier.

int

CLOUD_ID int

SWITCH_PORT_ID

The unique id of the switch TE port that this member
connects to.

int

TRUSTED

smallint

CREATION_TIME

timestamp

MISSING

smallint

MISSING_TIME timestamp

TABLE 223

GIGE_PORT_STATS

Field

Definition

Format

Size

ID*

Unique generated database identifier.

int

SWITCH_ID

References the ID in CORE_SWITCH table.

int

TABLE 221

GIGE_PORT (Continued)

Field

Definition

Format

Size

Advertising