HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 191
Fcip_tunnel_circuit_info, Where Fabric_member.fabric_id = Fabric.id As Switch_count
![]() |
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 191 highlights
Views E FABRIC.CONTACT, FABRIC.LOCATION, FABRIC.DESCRIPTION, FABRIC.CREATION_TIME, FABRIC.LAST_SCAN_TIME, FABRIC.LAST_UPDATE_TIME, FABRIC.TRACK_CHANGES, FABRIC.TYPE, FABRIC.USER_DEFINED_VALUE_1, FABRIC.USER_DEFINED_VALUE_2, FABRIC.USER_DEFINED_VALUE_3, FABRIC.PRINCIPAL_SWITCH_WWN, FABRIC.ZONE_TRANSACTION_TIMEOUT, FABRIC.FABRIC_MODEL, FABRIC.ENHANCED_TI_ZONE_SUPPORT, 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 or replace 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, Brocade Network Advisor Documentation Updates 183 53-1002363-02
![](/manual_guide/products/hewlettpackard-brocade-812c-brocade-network-advisor-documentation-updates-v111x-53100236303-2011-4c13200/191.png)