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

Brocade Network Advisor SAN User Manual 1547
53-1002948-01
Views
H
MODULE_INFO
CREATE VIEW module_info AS
select distinct
TEMP_MODULE.MODULE_ID,
TEMP_MODULE.NUM_PORTS,
TEMP_MODULE.IS_PRESENT,
case
when TEMP_MODULE.IS_PRESENT = 1 then 'YES'
else 'NO'
end as IS_PRESENT_TXT,
TEMP_MODULE.IS_MANAGEMENT_MODULE,
case
when TEMP_MODULE.IS_MANAGEMENT_MODULE = 1 then 'YES'
else 'NO'
end as IS_MANAGEMENT_MODULE_TXT,
TEMP_MODULE.NUM_CPUS,
TEMP_MODULE.HW_REVISION,
TEMP_MODULE.SW_REVISION,
TEMP_MODULE.SLOT_NUM,
TEMP_MODULE.DEVICE_ID,
TEMP_MODULE.PHYSICAL_DEVICE_ID,
TEMP_MODULE.UNIT_NUMBER,
TEMP_MODULE.UNIT_PRESENT,
case
when TEMP_MODULE.UNIT_PRESENT = 1 then 'YES'
else 'NO'
end as UNIT_PRESENT_TXT,
TEMP_MODULE.MANAGED_ELEMENT_ID,
TEMP_MODULE.IP_ADDRESS,
TEMP_FOUNDRY_MODULE.SERIAL_NUM,
TEMP_FOUNDRY_MODULE.DRAM_SIZE,
TEMP_FOUNDRY_MODULE.BOOT_FLASH_SIZE,
TEMP_FOUNDRY_MODULE.CODE_FLASH_SIZE,
TEMP_FOUNDRY_MODULE.MODULE_TYPE,
TEMP_MODULE.DESCRIPTION as MODULE_TYPE_TXT
from
(
select distinct
MODULE.MODULE_ID,
MODULE.NUM_PORTS,
MODULE.IS_PRESENT,
MODULE.IS_MANAGEMENT_MODULE,
MODULE.NUM_CPUS,
MODULE.HW_REVISION,
MODULE.SW_REVISION,
SLOT.SLOT_NUM,
PHYSICAL_DEVICE.DEVICE_ID,
PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID,
PHYSICAL_DEVICE.UNIT_NUMBER,
PHYSICAL_DEVICE.UNIT_PRESENT,
DEVICE.MANAGED_ELEMENT_ID,
DEVICE.IP_ADDRESS,
MODULE.DESCRIPTION
from MODULE, SLOT, MODULE_SLOT_PRESENT, DEVICE, PHYSICAL_DEVICE
where
MODULE.MODULE_ID = MODULE_SLOT_PRESENT.MODULE_ID
and MODULE_SLOT_PRESENT.SLOT_ID = SLOT.SLOT_ID
and SLOT.PHYSICAL_DEVICE_ID = PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID