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

1322 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
TABLE 367 USER_PREFERENCE
Field Definition Format Size
USER_NAME * User name whose preferences are saved. It corresponds
to user_name in USER_table.
varchar 128
CATEGORY * The name for a set of related preferences. varchar 128
CONTENT The set of preferences saved as name-value pairs. text
TABLE 368 USER_REALTIME_MEASURE_SETTING
Field Definition Format Size
ID Primary Key field for the
user_realtime_measure_setting table
int
USER_ID This is the foreign key reference key to the user_
Table
int
EXPRESSION_ID This is the foreign key reference key to the
snmp_expression Table
int
MIB_OBJECT_ID This is the foreign key reference key to the
mib_object Table
int
TYPE This identifies the collectible type. 0 for MIBs, 1 for
Expressions
int
TABLE 369 USER_RESOURCE_MAP
Field Definition Format Size
USER_NAME* User name. varchar 128
RESOURCE_GROUP_ID* Resource group name, which is mapped for the user. int
TABLE 370 USER_ROLE_MAP
Field Definition Format Size
USER_NAME* User name. varchar 128
ROLE_ID* Role ID, which is mapped for the user. int
TABLE 371 V_PORT_DETAIL
Field Definition Format Size
DEVICE_PORT_ID Primary key from the owner device port table. int
STATE Flag to indicate whether port is online or offline varchar 32
FCP_INITIATOR The role of the virtual port; for example, FCP Initiator varchar 256
SWITCH_IP IP of the switch, the V port is connected to varchar 128
VF_ID VF ID for the V port smallint