Fcip_tunnel_circuit_info – Brocade Network Advisor SAN + IP User Manual v12.3.0 User Manual

Page 2596

background image

2524

Brocade Network Advisor SAN + IP User Manual

53-1003155-01

Views

I

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