User's Manual

Brocade Network Advisor IP User Manual 1613
53-1003056-01
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,