Brocade Communications Systems Network Advisor 12.0.0, User Manual

Page: 1438 / 1505

1390 Brocade Network Advisor SAN User Manual
53-1002696-01
Views
H
and PHY_INTF.interface_id = LLDP_DATA.INTERFACE_ID;
MAPS_EVENT_DETAILS_INFO
create or replace view MAPS_EVENT_DETAILS_INFO as
select
MAPS_EVENT.ID,
MAPS_EVENT.HOST_TIME,
MAPS_EVENT.CATEGORY,
MAPS_EVENT.VIOLATION_TYPE,
MAPS_EVENT.MANAGED_ELEMENT_ID,
MAPS_EVENT.ORIGIN_FABRIC_ID,
MAPS_EVENT.SWITCH_PORT_ID,
MAPS_EVENT.FCIP_CIRCUIT_ID,
MAPS_EVENT.FRU_NAME,
MAPS_EVENT.VM_ID,
MAPS_EVENT_DETAILS.SWITCH_TIME,
MAPS_EVENT_DETAILS.RULE_NAME,
MAPS_EVENT_DETAILS.RULE_CONDITION,
MAPS_EVENT_DETAILS.TIME_BASE,
MAPS_EVENT_DETAILS.ACTIONS,
MAPS_EVENT_DETAILS.CURRENT_VALUE,
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;
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