Brocade Communications Systems IP250 user manual Nportwwnmapinfo, Physicaldevice.Deviceid

I Views

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

) TEMP_FOUNDRY_MODULE ON TEMP_MODULE.MODULE_ID = TEMP_FOUNDRY_MODULE.MODULE_ID;

NPORT_WWN_MAP_INFO

This view provides a consolidation between Nport WWN map and AG''s N and F ports. It considers only those N-Ports that are currently occupied that is having non-empty remote port wwn. This is required because NPort-WWN mapping might exist for NPorts that are not yet online and if a device is connected to AG through some F-Port that is mapped to some other N-Port that is online then AG will use that mapping.

create or replace view NPORT_WWN_MAP_INFO as select

NPORT_WWN_MAP.VIRTUAL_SWITCH_ID, NPORT_WWN_MAP.N_PORT, NPORT_WWN_MAP.DEVICE_PORT_WWN,

1638	Brocade Network Advisor IP User Manual
	53-1003056-01