Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2316)

Brocade Network Advisor SAN + IP User Manual 2279
53-1002949-01
Views
I
MAPS_EVENT_DETAILS.SWITCH_ENABLED_ACTIONS,
VIRTUAL_SWITCH.NAME as SWITCH_NAME,
SWITCH_PORT.NAME as SWITCH_PORT_NAME,
SWITCH_PORT.WWN as SWITCH_PORT_WWN,
SWITCH_PORT.SLOT_NUMBER as SWITCH_PORT_SLOT,
SWITCH_PORT.PORT_NUMBER as SWITCH_PORT_NUMBER,
SWITCH_PORT.PORT_ID as SWITCH_PORT_PORT_ID,
FCIP_TUNNEL_CIRCUIT.CIRCUIT_NUMBER,
FCIP_TUNNEL_CIRCUIT.SLOT_NUMBER as FCIP_SLOT_NUMBER,
FCIP_TUNNEL_CIRCUIT.VE_PORT_NUMBER as FCIP_PORT_NUMBER,
MAPS_EVENT_CAUSE_ACTION.CAUSE,
MAPS_EVENT_CAUSE_ACTION.ACTION
from
MAPS_EVENT_DETAILS
inner join
MAPS_EVENT on
MAPS_EVENT.ID = MAPS_EVENT_DETAILS.MAPS_EVENT_ID
left outer join MAPS_EVENT_CAUSE_ACTION
on MAPS_EVENT.VIOLATION_TYPE = MAPS_EVENT_CAUSE_ACTION.VIOLATION_TYPE
left outer join VIRTUAL_SWITCH
on MAPS_EVENT.MANAGED_ELEMENT_ID = VIRTUAL_SWITCH.MANAGED_ELEMENT_ID
left outer join SWITCH_PORT
on MAPS_EVENT.SWITCH_PORT_ID = SWITCH_PORT.ID
left outer join FCIP_TUNNEL_CIRCUIT
on MAPS_EVENT.FCIP_CIRCUIT_ID = FCIP_TUNNEL_CIRCUIT.ID;
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,