HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 67

Database tables and fields E TABLE 92 Field LICENSED_FEATURE Definition Format Size ID* NAME DESCRIPTION int License feature name, a short text description. varchar 64 Optional detailed description about the license varchar 256 feature. TABLE 93 Field SWITCH_LICENSE Definition Format Size ID* CORE_SWITCH_ID LICENSE_KEY int Refers to the entry in the CORE_SWITCH table. int Stores the license key obtained from the switch. varchar 256 TABLE 94 Field CORE_SWITCH Definition Format Size ID* int IP_ADDRESS IP address of the switch. varchar 128 WWN Chassis WWN. char 23 NAME Switch name. varchar 64 TYPE SWBD type number as given by Fabric OS. Default value is 0. smallint MODEL Model type of the switch: 0 = Unknown 1 = Not applicable 2 = Fabric OS switch 3 = M-EOS switch smallint FIRMWARE_VERSION Embedded (Fabric OS or M-EOS) software version. varchar 128 VENDOR Switch vendor. varchar 256 MAX_VIRTUAL_SWITCHES Maximum virtual switches allowed on this physical switch. Default vaue is 1. smallint NUM_VIRTUAL_SWITCHES Actual number of virtual switches carved out of this physical switch. 0 means it is not operating in Virtual Fabric model. Default value is 0. smallint REACHABLE Whether reachable by HTTP. smallint UNREACHABLE_TIME When the switch became unreachable from HTTP. timestamp OPERATIONAL_STATUS Operational status as reported by the embedded varchar 128 software.. CREATION_TIME Time when this record was created by the Management application. Default is 'now()'. timestamp LAST_SCAN_TIME Time when this record was last updated. timestamp Brocade Network Advisor Documentation Updates 59 53-1002363-02