Brocade Communications Systems Network Advisor 12.0.0, User Manual

Page: 1417 / 1505

Brocade Network Advisor SAN User Manual 1369
53-1002696-01
Views
H
VIRTUAL_SWITCH.FEATURES_ENABLED,
VIRTUAL_SWITCH.MAPS_ENABLED_ACTIONS,
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,
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,
SWITCH_PORT.ID as SWITCH_PORT_ID,
SWITCH_PORT.WWN as SWITCH_PORT_WWN,
SWITCH_PORT.NAME as SWITCH_PORT_NAME,
SWITCH_PORT.SLOT_NUMBER,
SWITCH_PORT.PORT_NUMBER,
SWITCH_PORT.PORT_INDEX,
SWITCH_PORT.TYPE as SWITCH_PORT_TYPE,
SWITCH_PORT.FULL_TYPE as SWITCH_PORT_FULL_TYPE,
SWITCH_PORT.STATUS as SWITCH_PORT_STATUS,
SWITCH_PORT.HEALTH as SWITCH_PORT_HEALTH,
SWITCH_PORT.SPEED,
SWITCH_PORT.MAX_PORT_SPEED,