Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1865)

Brocade Network Advisor SAN User Manual 1813
53-1003154-01
Views
H
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,
TEMP_MODULE.MODULE_STATUS,
TEMP_MODULE.REDUNDANT_STATUS
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,
MODULE.MODULE_STATUS,
MODULE.REDUNDANT_STATUS
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
and DEVICE.DEVICE_ID = PHYSICAL_DEVICE.DEVICE_ID
) TEMP_MODULE
left join
(
select
FOUNDRY_MODULE.MODULE_ID,
FOUNDRY_MODULE.SERIAL_NUM,
FOUNDRY_MODULE.DRAM_SIZE,
FOUNDRY_MODULE.BOOT_FLASH_SIZE,
FOUNDRY_MODULE.CODE_FLASH_SIZE,
FOUNDRY_MODULE.MODULE_TYPE
from FOUNDRY_MODULE