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

Brocade Network Advisor SAN User Manual 1167
53-1002696-01
Database tables and fields
H
NAME Name of the port varchar 256
MAC_ADDRESS MAC address of the port. varchar 64
MEDIA Media of the port varchar 64
CEE_STATE State of the port. varchar 64
HBA_ID ID of the port. int
CREATION_TIME CNA port record creation time. This tells when this port
was first discovered.
timestamp
FACTORY_PORT_WWN Factory configured Port WWN defined for the CNA port
in HCM
varchar 23
FACTORY_NODE_WWN Factory configured Node WWN defined for the CNA port
in HC
varchar 23
PREBOOT_CREATED Flag to identify vports created during preboot and will
accept string values True/false/empty
varchar 23
TABLE 53 COLLECTOR
Field Definition Format Size
NAME * Name of the collector registered with the collection
framework.
varchar 256
CLASS_NAME Java class name which serves as the collector. varchar 256
DESCRIPTION Collector description, usually not used. varchar 512
TABLE 54 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 55 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 56 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
TABLE 52 CNA_PORT (Continued)
Field Definition Format Size