User Manual v12.3.0 Owner's manual

Brocade Network Advisor IP User Manual 1555
53-1003153-01
Database tables and fields
I
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