Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1613)

Brocade Network Advisor SAN User Manual 1561
53-1003154-01
Database tables and fields
H
TABLE 98 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 99 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
DESCRIPTION Device group description. varchar 255
IS_PUBLIC Flag to identify whether this group is shared across
users. num (1,0)
IS_INTERNAL Flag to identify this group is internal. num (1,0)
TABLE_SUBTYPE Table subtype defined by BizObject framework varchar 32
IS_AP_GROUP Flag to identify whether this group is access point
device group. num (1,0)
IS_SENSOR_GROUP Flag to identify whether this group is sensor device
group. num (1,0)
VIEW_MASK Flag to decide whether to show the device group in
topology or not. num (1,0)
GROUP_TYPE This flag is to classify the device group type:
•
0 is the default and reserved for internal
temporary group
•
1 is for System Device Group
•
2 is for MPLS System Device Group
•
3 is for User Defined Device Group
int