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

1170 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
TABLE 58 CORE_SWITCH_CAPABILITY
Field Definition Format Size
CORE_SWITCH_ID * DB ID. int
CAPABILITY_ * Name of the capability detected on the core switch. varchar 256
ENABLED 1 = the capability is enabled on the core switch.
Default value is 0.
int
TABLE 59 CORE_SWITCH_CHECKSUM
Field Definition Format Size
CORE_SWITCH_ID * DB ID. int
CHECKSUM_KEY * Checksum type. varchar 32
CHECKSUM Checksum value. varchar 16
TABLE 60 CORE_SWITCH_COLLECTION
Field Definition Format Size
CORE_SWITCH_ID * Core switch ID. int
COLLECTION_NAME * Collector name. varchar 256
LAST_CORE_SW_
MODIFICATION
Last core switch modification time. timestamp
TABLE 61 CORE_SWITCH_DETAILS
Field Definition Format Size
CORE_SWITCH_ID* Primary key for the table. int
ETHERNET_MASK Ethernet mask of the core switch IP address. char 64
FC_MASK FC IP Address ethernet mask. char 64
FC_IP Fibre Channel IP address. char 64
FC_CERTIFICATE FC IP Address. smallint
SW_LICENSE_ID License ID of the chassis. char 23
SUPPLIER_SERIAL_
NUMBER
Supplier serial number for the switch. varchar 32
PART_NUMBER Partnumber of the switch varchar 32
CHECK_BEACON Denotes if Switch Beacon is enabled or not on the
switch.
1 = beacon is turned on; otherwise, 0.
smallint
TIMEZONE Timezone of the switch. varchar 32
MAX_PORT Number of maximum ports physically allowed on the
switch.
smallint
CHASSIS_SERVICE_TAG Chassis service tag for the switch. varchar 32
BAY_ID Bay ID of the switch. varchar 32
TYPE_NUMBER Type number is more of details for the type, Ex:
SLKWRM.
varchar 32