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

Brocade Network Advisor SAN User Manual 1251
53-1002696-01
Database tables and fields
H
TABLE 196 MCT_CLIENT
Field Definition Format Size
MCT_CLIENT_ID MCT Client db ID. int
RBRIDGE_ID MCT Client rbridge ID. int
CLIENT_NAME MCT Client name. varchar (100)
PORT_ID MCT Client port foreign key. int
OPER_STATE MCT Client operational state. smallint
DEPLOY_STATE MCT Client deployment state:
• Deployed(0)
• Undeployed(1)
smallint
VCN_MEMBER_ID Virtual Cluster Node member Cluster id foreign key. int
TABLE 198 MAC_FILTER_DEV_DEPLOYMENT_MAP
Field Definition Format Size
DEPLOYMENT_ID Deployment configuration ID. int
MAC_FILTER_ID MAC FILTER Id for reference to the MAC_FILTER. int
TABLE 199 MAC_FILTER_INT_DEPLOYMENT_MAP
Field Definition Format Size
ID Unique generated database identifier. serial
DEPLOYMENT_ID Deployment configuration ID. Foreign Key for
DEPLOYMENT table.
int
INBOUND_MAC_FILTER_ID MAC FILTER Id of the MAC Filter selected for inbound.
Foreign Key for MAC_FILTER table.
int
INBOUND_WRITE_TO_DEVICE 1/0 corresponding to Write to device/not write to
device for inbound traffic.
smallint
TABLE 200 MANAGED_ELEMENT
Field Definition Format Size
ID An ID that is unique across managed elements of all
types: SAN physical switches, SAN logical switches, IP
switches, and hosts. Also the primary key for the
MANAGED_ELEMENT table.
int
PLACEHOLDER Not used. iBatis/Abator requires at least one non-serial
column to generate correct objects. The default value is
0.
int
TABLE 201 MAPS_EVENT
Field Definition Format Size
ID The primary key of the table. int
HOST_TIME The time at which the server processed the event. timestamp
CATEGORY The violations category. i.e. Port Health, Fabric Health,
etc.
int