Brocade Network Advisor SAN User Manual v12.1.0 - Manual (Page 1604)

Brocade Network Advisor SAN User Manual 1557
53-1002948-01
Views
H
FABRIC.USER_DEFINED_VALUE_3,
FABRIC.PRINCIPAL_SWITCH_WWN,
FABRIC.ZONE_TRANSACTION_TIMEOUT,
FABRIC.FABRIC_MODEL,
FABRIC.ENHANCED_TI_ZONE_SUPPORT,
FABRIC.FABRIC_NAME,
VIRTUAL_SWITCH.ID as SEED_SWITCH_ID,
VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID,
VIRTUAL_SWITCH.INTEROP_MODE,
CORE_SWITCH.IP_ADDRESS as SEED_SWITCH_IP_ADDRESS,
(select count(*) from FABRIC_MEMBER
where FABRIC_MEMBER.FABRIC_ID = FABRIC.ID) as SWITCH_COUNT
from
FABRIC, CORE_SWITCH, VIRTUAL_SWITCH, FABRIC_MEMBER
where
FABRIC.SEED_SWITCH_WWN = VIRTUAL_SWITCH.WWN and
VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID and
FABRIC_MEMBER.FABRIC_ID = FABRIC.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,