Views I

VIRTUAL_SWITCH.FCOE_CAPABLE, VIRTUAL_SWITCH.L2_CAPABLE, VIRTUAL_SWITCH.L3_CAPABLE, VIRTUAL_SWITCH.DEFAULT_LOGICAL_SWITCH, VIRTUAL_SWITCH.FEATURES_SUPPORTED, VIRTUAL_SWITCH.FMS_MODE, VIRTUAL_SWITCH.DYNAMIC_LOAD_SHARING, VIRTUAL_SWITCH.PORT_BASED_ROUTING, VIRTUAL_SWITCH.IN_ORDER_DELIVERY, VIRTUAL_SWITCH.INSISTENT_DID_MODE, VIRTUAL_SWITCH.PREVIOUS_OPERATIONAL_STATUS, VIRTUAL_SWITCH.LAST_SCAN_TIME, VIRTUAL_SWITCH.DOMAIN_MODE_239,

VIRTUAL_SWITCH.DOMAIN_ID_OFFSET, VIRTUAL_SWITCH.DISCOVERED_PORT_COUNT, VIRTUAL_SWITCH.FCOE_LOGIN_ENABLED, VIRTUAL_SWITCH.LAST_PORT_MEMBERSHIP_CHANGE, VIRTUAL_SWITCH.FCIP_CIRCUIT_CAPABLE, VIRTUAL_SWITCH.MAX_FCIP_TUNNELS, VIRTUAL_SWITCH.MAX_FCIP_CIRCUITS, VIRTUAL_SWITCH.FCIP_LICENSED, VIRTUAL_SWITCH.ADDRESSING_MODE, VIRTUAL_SWITCH.PREVIOUS_STATE, VIRTUAL_SWITCH.MANAGED_ELEMENT_ID, VIRTUAL_SWITCH.HIF_ENABLED, VIRTUAL_SWITCH.AUTO_SNMP, VIRTUAL_SWITCH.RNID_SEQUENCE_NUMBER, VIRTUAL_SWITCH.VCS_ID, VIRTUAL_SWITCH.CLUSTER_TYPE, VIRTUAL_SWITCH.CLUSTER_MODE, VIRTUAL_SWITCH.RNID_TAG, VIRTUAL_SWITCH.SWITCH_ID, VIRTUAL_SWITCH.MONITORED, VIRTUAL_SWITCH.FEATURES_ENABLED, VIRTUAL_SWITCH.MAPS_ENABLED_ACTIONS, VIRTUAL_SWITCH.FABRIC_STATUS, FABRIC_MEMBER.FABRIC_ID, FABRIC_MEMBER.TRUSTED, FABRIC_MEMBER.MISSING, FABRIC_MEMBER.MISSING_TIME, FABRIC.MANAGED as FABRIC_MANAGED, FABRIC.PRINCIPAL_SWITCH_WWN, FABRIC.SEED_SWITCH_WWN,

FABRIC.TYPE as FABRIC_TYPE from

CORE_SWITCH, VIRTUAL_SWITCH, FABRIC_MEMBER, FABRIC

where

VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID

and FABRIC_MEMBER.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID and FABRIC_MEMBER.FABRIC_ID = FABRIC.ID;

DEVICE_INFO

create or replace view DEVICE_INFO as select distinct

DEVICE_NODE.ID as DEVICE_NODE_ID,

Brocade Network Advisor IP User Manual

1613

53-1003056-01

 

Page 1665
Image 1665
Brocade Communications Systems IP250 user manual Deviceinfo, CORESWITCH, VIRTUALSWITCH, FABRICMEMBER, Fabric