Brocade Network Advisor SAN + IP User Manual v12.3.0 - Manual (Page 2611)

Brocade Network Advisor SAN + IP User Manual 2539
53-1003155-01
Views
I
FCIP_TUNNEL.VIRTUAL_SWITCH_ID, DP0_SWITCH_PORT.USER_PORT_NUMBER,
DP1_GIGE_PORT.PORT_NUMBER as DP1_GIGE_PORT_NUMBER,
DP1_GIGE_PORT.SLOT_NUMBER as DP1_GIGE_PORT_SLOT_NUMBER,
FCIP_CIRCUIT_PORT_MAP.DP1_SWITCH_PORT_ID as DP1_GIGE_PORT_ID,
DP1_SWITCH_PORT.USER_PORT_NUMBER as DP1_USER_PORT_NUMBER
from FCIP_TUNNEL,
FCIP_TUNNEL_CIRCUIT
left join FCIP_CIRCUIT_PORT_MAP on FCIP_CIRCUIT_PORT_MAP.CIRCUIT_ID =
FCIP_TUNNEL_CIRCUIT.ID
left join GIGE_PORT as DP0_GIGE_PORT on FCIP_CIRCUIT_PORT_MAP.SWITCH_PORT_ID =
DP0_GIGE_PORT.ID
left join SWITCH_PORT as DP0_SWITCH_PORT on DP0_GIGE_PORT.SWITCH_PORT_ID =
DP0_SWITCH_PORT.ID
left join GIGE_PORT as DP1_GIGE_PORT ON
FCIP_CIRCUIT_PORT_MAP.DP1_SWITCH_PORT_ID = DP1_GIGE_PORT.ID
left join SWITCH_PORT as DP1_SWITCH_PORT ON DP1_GIGE_PORT.SWITCH_PORT_ID =
DP1_SWITCH_PORT.ID
where FCIP_TUNNEL_CIRCUIT.TUNNEL_ID = FCIP_TUNNEL.ID;
IFL_INFO
create or replace view IFL_INFO as
select
IFL.ID as IFL_ID,
IFL.EDGE_FABRIC_ID,
(select distinct FCR_PORT.VIRTUAL_SWITCH_ID
from SWITCH_PORT FCR_PORT
where FCR_PORT.WWN = IFL.BB_PORT_WWN)
as FCR_SWITCH_ID,
IFL.EDGE_PORT_WWN,
IFL.BB_FABRIC_ID,
IFL.BB_PORT_WWN ,
IFL.BB_RA_TOV,
IFL.BB_ED_TOV,
IFL.BB_PID_FORMAT,
SWITCH_PORT.VIRTUAL_SWITCH_ID as EDGE_SWITCH_ID,
SWITCH_PORT.ID as EDGE_PORT_ID,
SWITCH_PORT.USER_PORT_NUMBER as EDGE_PORT_NUMBER,
SWITCH_PORT.TYPE as EDGE_PORT_TYPE
from IFL
left outer join SWITCH_PORT
on IFL.EDGE_PORT_WWN = SWITCH_PORT.WWN;
IFL_REPORT_INFO
CREATE OR REPLACE VIEW ifl_report_info AS
SELECT
ifl.id AS ifl_id,
ifl.edge_fabric_id,
edge_fabric.id AS edge_fabric_db_id,
ifl.bb_fabric_id,
ifl.edge_port_wwn,
ifl.bb_port_wwn,
ifl.bb_ra_tov,
ifl.bb_ed_tov,
ifl.bb_pid_format,
bb_switch_port.virtual_switch_id AS bb_virtual_switch_id,
bb_switch_port.id AS bb_switch_port_id,