Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

Brocade Network Advisor SAN User Manual 1189
53-1002696-01
Database tables and fields
H
MANAGED_BY 1 - Manual - (user created not managed condition) -
Default.
2 - Host Adapter
3 - VMM 4.Both Host Adapter and VMM';
smallint
QUEUE_DEPTH Queue Depth can be used to control FCP exchange
resource allocation. Queue depth can range from 0 to
254 and default value is 32.
int
TABLE 78 DEVICE_ENCLOSURE_MEMBER
Field Definition Format Size
ENCLOSURE_ID* DEVICE_ENCLOSURE table ID. int
DEVICE_PORT_WWN* WWN Of Device Port. char 23
DEVICE_PORT_ID Device_Port table ID. int
TABLE 79 DEVICE_FDMI_DETAILS
Field Definition Format Size
DEVICE_NODE_ID Device node id for the FDMI device node. This
column refers to the device_node tables
primary key
int
SERIAL_NUMBER Holds the serial number of the device available
via FDMI
varchar 128
FIRMWARE_VERSION Holds the firmware version of the device
available via FDMI ex: 2.1.0.2
varchar 64
DRIVER_VERSION Holds the driver version of the device available
via FDMI, ex: 2.1.0.2
varchar 64
MANUFACTURER Holds the manufacturer of the device available
via FDMI, ex : Brocade
varchar 64
MODEL Holds the model of the device available via
FDMI, ex : Brocade-825
varchar 64
HARDWARE_VERSION Holds the hardware version of the device
available via FDMI, ex: Rev-C
varchar 64
MODEL_DESCRIPTION Holds the model description of the device
available via FDMI, ex : Brocade-825
varchar 64
NODE_NAME Holds the node name of the device available
via FDMI, ex : 20:00:00:05:1e:7c:64:94
varchar 64
TABLE 80 DEVICE_GROUP
Field Definition Format Size
DEVICE_GROUP_ID Primary key for this table. int
NAME Name of this device group. varchar 128
USER_ID User ID corresponds to the user who created the
device.
int
TABLE 77 DEVICE_ENCLOSURE (Continued)
Field Definition Format Size