Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

1150 Brocade Network Advisor SAN User Manual
53-1002167-01
Views
E
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,
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
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,
DEVICE_NODE.WWN as DEVICE_NODE_WWN,
DEVICE_NODE.TYPE as DEVICE_NODE_TYPE,
DEVICE_NODE.SYMBOLIC_NAME as DEVICE_NODE_SYMBOLIC_NAME,
DEVICE_NODE.DEVICE_TYPE,
DEVICE_NODE.FDMI_HOST_NAME,
DEVICE_NODE.VENDOR,
DEVICE_NODE.CAPABILITY_,
DEVICE_NODE.AG,
DEVICE_PORT.ID as DEVICE_PORT_ID,
DEVICE_PORT.DOMAIN_ID as DEVICE_PORT_DOMAIN_ID,
DEVICE_PORT.WWN as DEVICE_PORT_WWN,
DEVICE_PORT.NUMBER,
DEVICE_PORT.PORT_ID,
DEVICE_PORT.TYPE as DEVICE_PORT_TYPE,
DEVICE_PORT.SYMBOLIC_NAME as DEVICE_PORT_SYMBOLIC_NAME,
DEVICE_PORT.FC4_TYPE,
DEVICE_PORT.IP_PORT,
DEVICE_PORT.HARDWARE_ADDRESS,
DEVICE_PORT.TRUSTED as DEVICE_PORT_TRUSTED,
DEVICE_PORT.MISSING as DEVICE_PORT_MISSING,
DEVICE_PORT.COS,
DEVICE_PORT.NPV_PHYSICAL,