Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2086)

Brocade Network Advisor SAN + IP User Manual 2049
53-1002949-01
Database tables and fields
I
TABLE 138 COLLECTOR_MIB_OBJECT_ENTRY
Field Definition Format Size
COLLECTOR_MIB_OBJECT_
ENTRY_ID Primary key autogenerated ID. int
COLLECTOR_ID ID of the PERF_COLLECTOR. int
MIB_OBJECT_ID MIB_OBJECT table DB ID. int
TABLE 139 COLLECTOR_SNMP_EXPRESSION_ENTRY
Field Definition Format Size
COLLECTOR_SNMP_EXPRE
SSION_ENTRY_ID Primary key autogenerated ID. int
COLLECTOR_ID ID of the PERF_COLLECTOR. int
EXPRESSION_ID Id of the SNMP_EXPRESSION. int
TABLE 140 COLLECTOR_TARGET_ENTRY
Field Definition Format Size
COLLECTOR_TARGET_ENTR
Y_ID Primary key autogenerated ID. int
COLLECTOR_ID ID of the PERF_COLLECTOR. int
TARGET_ID Target ID of the SNMP collector data. For device level
collector it will use deviceId, and for port level it will
use interfaceId. int
PROP_STR Property string of the PERF_COLLECTOR. varchar 8192
COLLECTOR_TARGET_ENTR
Y_TYPE Target type of the SNMP collector data. for device
level collector the target type is 0, for port level it is 1. int
TABLE 141 CORE_SWITCH
Field Definition Format Size
ID* Auto generated ID for this table. int
IP_ADDRESS IP Address of the switch that is represented by this
record. Could be either IPV4 or IPV6 address. varchar 128
WWN WWN of the core switch. char 23
NAME Switch name if available otherwise stores the wwn of
the switch. varchar 64
TYPE Stores the switch type, the sw_bd_type of the switch. smallint
MODEL Holds the switch model, whether its Brocade, Mcdata
or unknown . Value 2 is for Brocade and 3 is for
McData smallint
FIRMWARE_VERSION Firmware version of the switch. varchar 128
VENDOR Vendor information for the switch. varchar 256
MAX_VIRTUAL_SWITCHES Maximum number of virtual switches supported. smallint
NUM_VIRTUAL_SWITCHES Total number of virtual switch present. smallint