Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

1390 Brocade Network Advisor SAN User Manual
53-1002948-01
Database tables and fields
H
TABLE 195 FIRMWARE_FILE_DETAIL
Field Definition Format Size
ID* Unique generated database identifier. int
FIRMWARE_NAME Name of the firmware file. varchar 64
MAJOR_VERSION Major version bit from the firmware version. smallint
MINOR_VERSION Minor version bit from the firmware version. smallint
MAINTENANCE Maintenance bit from the firmware version. smallint
PATCH Patch bit from the firmware version. varchar 64
PHASE Phase bit from the firmware version. varchar 64
RELEASE_DATE Release date of the firmware file. timestamp
IMPORTED_DATE Imported date of the file to the Management
applciation.
timestamp
FIRMWARE_FILE_SIZE Firmware file size. int
FIRMWARE_LOCATION Firmware file location in the Management applciation
repository.
varchar 1024
RELEASE_NOTES_
LOCATION
Release notes file location in theManagement
applciation repository.
varchar 1024
FIRMWARE_REPOSITORY_
TYPE
Repository type to identify the FTP server:
0 = internal FTP.
1 = external FTP.
smallint
TABLE 196 FIRMWARE_SWITCH_DETAIL
Field Definition Format Size
FIRMWARE_ID* ID for the firmware file. int
SWITCH_TYPE* Switch type that supports this firmware file. smallint
REBOOT_REQUIRED Reboot required flag for the switch type. smallint
NUMFILES Number of files in the firmware. int
TABLE 197 FOUNDRY_DEVICE
Field Definition Format Size
DEVICE_ID Database ID of the DEVICE instance. int
IMAGE_VERSION Firmware image version currently running in the
device.
varchar 128
PRODUCT_TYPE Product type of the device computed based on sysoid
and version of main board. To get the main board
version for devices, refer octet 28 of
snChasMainBrdId MIB in foundry.mib.
varchar 32
FEATURE_MASK A bit string representing the software features
available in the switch/router. Each bit represent a
feature and if the feature available then bit value
would be 1 and 0 otherwise. Refer
snAgSoftwareFeature MIB in foundry.MIB for various
features supported and its corresponding details.
bytea