User's Manual

1444 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
TABLE 156 FRU
Field Definition Format Size
ID Unique generated database identifier. int
CORE_SWITCH_ID int
TAG provides the TAG number of FRU element, requested by
SMIA and values filled in by Switch Asset Collector. Field
probably contains information such as asset tag or
serial number data. This value varies depending on the
type of physical package
varchar 64
PART_NUMBER provides the part number of the FRU element,
requested by SMIA and values filled in by Switch Asset
Collector. Field probably contains the part number
assigned by the organization responsible for producing
or manufacturing the physical element
varchar 64
SERIAL_NUMBER provides the serial number of the FRU element,
requested by SMIA and values filled in by Switch Asset
Collector
varchar 64
VENDOR_PART_
NUMBER
provides the Vendor-assigned part number of this
package, requested by SMIA and values filled in by
Switch Asset Collector
varchar 64
VENDOR_SERIAL_
NUMBER
provides the Vendor-assigned serial number of this
package, requested by SMIA and values filled in by
Switch Asset Collector'
varchar 64
CAN_BE_FRUED provides whether this element can be removed from the
switch, requested by SMIA and values filled in by Switch
Asset Collector. Maps to IsRemovable field in the html.
The default value is -1.
int
SLOT_NUMBER provides the slot number of this FRU element ,
requested by SMIA and values filled in by Switch Asset
Collector.The default value is -1.
int
MANUFACTURER_DATE provides the manufactured date of this FRU element,
requested by SMIA and values filled in by Switch Asset
Collector
timestamp
UPDATE_DATE provides the updated date of this FRU element,
requested by SMIA and values filled in by Switch Asset
Collector
timestamp
VERSION varchar 32
MANUFACTURER provides the manufacturer of this FRU element
,requested by SMIA and values filled in by Switch Asset
Collector
varchar 64
VENDOR_EQUIPMENT_T
YPE
provides the vendor equipment type of the FRU
element, requested by SMIA and values filled in by
Switch Asset Collector
varchar 32
OPERATIONAL_STATUS provides the operational status of the FRU element,
requested by SMIA and values filled in by Switch Asset
Collector will be available only from FOS 6.4 switches
and above. The default value is -1.
int