Database tables and fields

I

TABLE 91

DEVICE (Continued)

 

 

 

 

 

 

 

 

Field

 

Definition

Format

Size

 

 

 

 

USER_DEFINED_VALUE_1

User defined value used for product.

varchar

256

 

 

 

 

USER_DEFINED_VALUE_2

User defined value used for product.

varchar

256

 

 

 

 

USER_DEFINED_VALUE_3

User defined value used for product.

varchar

256

 

 

 

 

CLUSTER_MEMBER_STATE

Indicates the state of the member in Fabric

varchar

64

 

 

Cluster and logical chassis. States can be

 

 

 

 

Online, Offline, Rejoining etc.. For all other

 

 

 

 

devices this column will be empty.

 

 

 

 

 

 

 

MODE

 

Denotes the mode of the device. 1 denotes it is

int

 

 

 

in non-AG mode and 2 denotes that the device is

 

 

 

 

in AG mode.-1 denotes not applicable and will

 

 

 

 

be set to all non NOS devices.

 

 

 

 

 

 

 

TABLE 92

DEVICE_CONNECTION

 

 

 

 

 

 

 

Field

 

Definition

Format

Size

 

 

 

 

 

ID

 

The primary key.

int

 

 

 

 

 

 

FABRIC_ID

 

ID of the fabric which the device port is connected to.

int

 

 

 

It refers the ID column of FABRIC table.

 

 

 

 

 

 

DEVICE_PORT_ID

ID of end device port. It refers ID field of

int

 

 

 

DEVICE_PORT table.

 

 

 

 

 

 

SWITCH_PORT_ID

ID of switch port which end device port is connected.

int

 

 

 

In case device port is connected through AG, this port

 

 

 

 

refer the switch port which AG is connected. It refers

 

 

 

 

to the ID field of SWITCH_PORT table.

 

 

 

 

 

 

 

AG_PORT_ID

 

In case of AG, this would refer to F Port of the AG

int

 

 

 

which end device port is connected. If the device port

 

 

 

 

is directly connected to switch port or NPIV

 

 

 

 

connection then it would be -1. It refers to the ID field

 

 

 

 

of SWITCH_PORT table for the access gateway

 

 

 

 

switches.

 

 

 

 

 

 

CREATION_TIME

Time at which the device connection record is

timestamp

 

 

 

created.

 

 

 

 

 

 

LAST_UPDATED_TIME

Time at which connection properties are modified for

timestamp

 

 

 

this record.

 

 

 

 

 

 

 

MISSING

 

Indicates if the device connection is missing or not.

int

 

 

 

 

 

MISSING_TIME

Time from which the device connection has been

timestamp

 

 

 

missing.

 

 

 

 

 

 

 

TRUSTED

 

Indicates if the device connection is trusted or not.

int

 

 

 

 

 

 

TABLE 93

DEVICE_ENCLOSURE

 

 

 

 

 

 

Field

Definition

Format

Size

 

 

 

 

ID*

Unique generated database identifier.

int

 

 

 

 

 

NAME

Name of the Device enclosure.

varchar

256

 

 

 

 

TYPE

Type of Device enclosure - Storage Array/Server.

varchar

32

Brocade Network Advisor IP User Manual

1409

53-1003056-01

 

Page 1461
Image 1461
Brocade Communications Systems IP250 user manual Deviceconnection, Deviceenclosure