Fcip_tunnel_circuit_info – Brocade Network Advisor SAN User Manual v12.3.0 User Manual
Page 1836
1784
Brocade Network Advisor SAN User Manual
53-1003154-01
Views
H
FABRIC.SEED_SWITCH_WWN = VIRTUAL_SWITCH.WWN and
VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID;
FCIP_TUNNEL_CIRCUIT_INFO
CREATE VIEW fcip_tunnel_circuit_info AS
select
FCIP_TUNNEL_CIRCUIT.ID,
FCIP_TUNNEL_CIRCUIT.TUNNEL_ID,
FCIP_TUNNEL_CIRCUIT.CIRCUIT_NUMBER,
FCIP_TUNNEL_CIRCUIT.COMPRESSION_ENABLED,
FCIP_TUNNEL_CIRCUIT.TURBO_WRITE_ENABLED,
FCIP_TUNNEL_CIRCUIT.TAPE_ACCELERATION_ENABLED,
FCIP_TUNNEL_CIRCUIT.IKE_POLICY_NUM,
FCIP_TUNNEL_CIRCUIT.IPSEC_POLICY_NUM,
FCIP_TUNNEL_CIRCUIT.PRESHARED_KEY,
FCIP_TUNNEL_CIRCUIT.SOURCE_IP,
FCIP_TUNNEL_CIRCUIT.DEST_IP,
FCIP_TUNNEL_CIRCUIT.VLAN_TAG,
FCIP_TUNNEL_CIRCUIT.SELECTIVE_ACK,
FCIP_TUNNEL_CIRCUIT.QOS_MAPPING,
FCIP_TUNNEL_CIRCUIT.PATH_MTU_DISCOVERY,
FCIP_TUNNEL_CIRCUIT.MIN_COMM_RATE,
FCIP_TUNNEL_CIRCUIT.MAX_COMM_RATE,
FCIP_TUNNEL_CIRCUIT.MIN_RETRANSMIT_TIME,
FCIP_TUNNEL_CIRCUIT.MAX_RETRANSMIT_TIME,
FCIP_TUNNEL_CIRCUIT.KEEP_ALIVE_TIMEOUT,
FCIP_TUNNEL_CIRCUIT.ADMIN_STATUS,
FCIP_TUNNEL_CIRCUIT.METRIC,
FCIP_TUNNEL_CIRCUIT.DATA_L2_COS,
FCIP_TUNNEL_CIRCUIT.DSCP_DATA,
FCIP_TUNNEL_CIRCUIT.MAX_RETRANSMISSIONS,
FCIP_TUNNEL_CIRCUIT.SLOT_NUMBER,
FCIP_TUNNEL_CIRCUIT.VE_PORT_NUMBER,
FCIP_TUNNEL_CIRCUIT.SECURITY_FLAG,
FCIP_TUNNEL_CIRCUIT.DSCP_CONTROL,
FCIP_TUNNEL_CIRCUIT.CIRCUIT_STATUS,
FCIP_TUNNEL_CIRCUIT.ENABLED,
FCIP_TUNNEL_CIRCUIT.MISMATCHED_CONFIGURATIONS,
FCIP_TUNNEL_CIRCUIT.CIRCUIT_STATUS_STRING,
FCIP_TUNNEL_CIRCUIT.L2COS_F_CLASS,
FCIP_TUNNEL_CIRCUIT.L2_COS_HIGH,
FCIP_TUNNEL_CIRCUIT.L2_COS_MEDIUM,
FCIP_TUNNEL_CIRCUIT.L2_COS_LOW,
FCIP_TUNNEL_CIRCUIT.DSCP_F_CLASS,
FCIP_TUNNEL_CIRCUIT.DSCP_HIGH,
FCIP_TUNNEL_CIRCUIT.DSCP_MEDIUM,
FCIP_TUNNEL_CIRCUIT.DSCP_LOW,
FCIP_TUNNEL_CIRCUIT.FAILOVER_CIRCUIT,
FCIP_TUNNEL_CIRCUIT.FAILOVER_GROUP_ID,
GIGE_PORT.PORT_NUMBER GIGE_PORT_NUMBER,
GIGE_PORT.SLOT_NUMBER GIGE_PORT_SLOT_NUMBER,
FCIP_CIRCUIT_PORT_MAP.SWITCH_PORT_ID GIGE_PORT_ID,
SWITCH_PORT.VIRTUAL_SWITCH_ID,
SWITCH_PORT.USER_PORT_NUMBER
from
FCIP_TUNNEL_CIRCUIT
left outer join FCIP_CIRCUIT_PORT_MAP on
FCIP_CIRCUIT_PORT_MAP.CIRCUIT_ID = FCIP_TUNNEL_CIRCUIT.ID