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

Brocade Network Advisor SAN User Manual 1809
53-1003154-01
Views
H
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 JOIN INTERFACE ON MAPS_EVENT.INTERFACE_ID = INTERFACE.INTERFACE_ID
left outer join FCIP_TUNNEL_CIRCUIT
on MAPS_EVENT.FCIP_CIRCUIT_ID = FCIP_TUNNEL_CIRCUIT.ID
left outer join NP_FLOW_DEFINITION
on MAPS_EVENT.FLOW_DEFINITION_ID = NP_FLOW_DEFINITION.ID;
N2F_PORT_MAP_REPORT_INFO
create or replace view N2F_PORT_MAP_REPORT_INFO as
select
AG_N_PORT.REMOTE_PORT_WWN as EDGE_SWITCH_PORT_WWN,
AG_N_PORT.WWN as AG_N_PORT_WWN,
AG_N_PORT.VIRTUAL_SWITCH_ID as AG_VIRTUAL_SWITCH_ID,
EDGE_SWITCH_PORT.VIRTUAL_SWITCH_ID as EDGE_SWITCH_PORT_VSID,
EDGE_SWITCH_PORT.SLOT_NUMBER as EDGE_SWITCH_PORTSLOT_NUMBER,
EDGE_SWITCH_PORT.PORT_NUMBER as EDGE_SWITCH_PORT_NUMBER,
EDGE_SWITCH_PORT.USER_PORT_NUMBER as EDGE_SWITCH_PORT_USER_PORT_NUMBER,
EDGE_SWITCH_PORT.NAME as EDGE_SWITCH_PORT_NAME,
EDGE_SWITCH_PORT.SPEED as EDGE_SWITCH_PORT_SPEED,
EDGE_SWITCH_PORT.STATUS as EDGE_SWITCH_PORT_STATUS,
EDGE_SWITCH_PORT.STATE as EDGE_SWITCH_PORT_STATE,
EDGE_SWITCH_PORT.TYPE as EDGE_SWITCH_PORT_TYPE,
EDGE_SWITCH_PORT.SPEEDS_SUPPORTED as EDGE_SWITCH_PORT_SPEEDS_SUPPORTED,
EDGE_SWITCH_PORT.PHYSICAL_PORT as EDGE_SWITCH_PORT_PHYSICAL_OR_LOGICAL_PORT,
EDGE_SWITCH_PORT.PORT_INDEX as EDGE_SWITCH_PORT_ZONING_PORT_INDEX,
EDGE_SWITCH_PORT.PORT_ID as EDGE_SWITCH_PORT_ID,
EDGE_SWITCH_PORT.AREA_ID as EDGE_SWITCH_PORT_AREA_ID,
EDGE_SWITCH_PORT.MAC_ADDRESS as EDGE_SWITCH_PORT_MAC_ADDRESS,
EDGE_SWITCH_PORT.PORT_MOD as EDGE_SWITCH_PORT_MOD,
EDGE_SWITCH_PORT.FULL_TYPE as EDGE_SWITCH_PORT_FULL_TYPE,
EDGE_SWITCH_PORT.HEALTH as EDGE_SWITCH_PORT_HEALTH,
EDGE_SWITCH_PORT.STATUS_MESSAGE as EDGE_SWITCH_PORT_STATUS_MESSAGE,
EDGE_SWITCH_PORT.MAX_PORT_SPEED as EDGE_SWITCH_PORT_MAX_PORT_SPEED,
EDGE_SWITCH_PORT.LICENSED as EDGE_SWITCH_PORT_LICENSED,
EDGE_SWITCH_PORT.REMOTE_NODE_WWN as EDGE_SWITCH_PORT_REMOTE_NODE_WWN,
EDGE_SWITCH_PORT.REMOTE_PORT_WWN as EDGE_SWITCH_PORT_REMOTE_PORT_WWN,
EDGE_SWITCH_PORT.TRUNKED as EDGE_SWITCH_PORT_TRUNKED,
EDGE_SWITCH_PORT.TRUNK_MASTER as EDGE_SWITCH_PORT_TRUNK_MASTER,
EDGE_SWITCH_PORT.FICON_SUPPORTED as EDGE_SWITCH_PORT_FICON_SUPPORTED,
EDGE_SWITCH_PORT.BLOCKED as EDGE_SWITCH_PORT_BLOCKED,
EDGE_SWITCH_PORT.NPIV as EDGE_SWITCH_PORT_NPIV,
EDGE_SWITCH_PORT.NPIV_CAPABLE as EDGE_SWITCH_PORT_NPIV_CAPABLE,
EDGE_SWITCH_PORT.NPIV_ENABLED as EDGE_SWITCH_PORT_NPIV_ENABLED,
EDGE_SWITCH_PORT.QOS_CAPABLE as EDGE_SWITCH_PORT_QOS_CAPABLE,
EDGE_SWITCH_PORT.QOS_ENABLED as EDGE_SWITCH_PORT_QOS_ENABLED,
EDGE_SWITCH_PORT.TUNNEL_CONFIGURED as EDGE_SWITCH_PORT_TUNNEL_CONFIGURED,
EDGE_SWITCH_PORT.FCR_FABRIC_ID as EDGE_SWITCH_PORT_FCR_FABRIC_ID,
EDGE_SWITCH_PORT.FCR_INTEROP_MODE as EDGE_SWITCH_PORT_FCR_INTEROP_MODE,
EDGE_SWITCH_PORT.USER_DEFINED_VALUE1 as EDGE_SWITCH_PORT_USER_DEFINED_VALUE1,
EDGE_SWITCH_PORT.USER_DEFINED_VALUE2 as EDGE_SWITCH_PORT_USER_DEFINED_VALUE2,
EDGE_SWITCH_PORT.USER_DEFINED_VALUE3 as EDGE_SWITCH_PORT_USER_DEFINED_VALUE3,