Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

Brocade Network Advisor SAN User Manual 1087
53-1002167-01
Database tables and fields
E
TABLE 289 CNA_PORT
Field Definition Format Size
ID Primary key autogenerated ID int
PORT_NUMBER Port number of the CNA port int
PORT_WWN Port WWN of the port char 23
NODE_WWN Node WWN of the port char 23
PHYSICAL_PORT_TYPE Port type CNA/FC varchar 32
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 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 290 COLLECTION_END_TIMESTAMP
Field Definition Format Size
COLLECTOR_SOURCE varchar 256
COLLECTOR_NAME varchar 256
TIMESTAMP_ timestamp
LAST_COLLECTED_STATUS The default value is 0. smallint
FIRST_COLLECTION_TIME
STAMP
timestamp
SUCCESSFUL_RUNS bigint
FAILED_RUNS bigint
LAST_FAILURE_TIMESTAM
P
timestamp
LAST_SUCCESSFUL_TIME
STAMP
timestamp
TABLE 291 COLLECTOR_END_TIMESTAMP
Field Definition Format Size
COLLECTOR_SOURCE * Internal key for switches and fabrics for which
collection is undertaken.
varchar 256
COLLECTOR_NAME * Collection name, Java class used to collect specific
fabric or switch information.
varchar 256