Brocade Network Advisor SAN User Manual v12.1.0 - Manual (Page 1595)

1548 Brocade Network Advisor SAN User Manual
53-1002948-01
Views
H
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,
SWITCH_PORT.NPIV,
SWITCH_PORT.NPIV_CAPABLE,
SWITCH_PORT.CALCULATED_STATUS,
SWITCH_PORT.AREA_ID,
SWITCH_PORT.PHYSICAL_PORT,
SWITCH_PORT.CATEGORY,
SWITCH_PORT.PERSISTENT_DISABLE,
SWITCH_PORT.BLOCKED,
SWITCH_PORT.FCR_INTEROP_MODE,
SWITCH_INFO.IP_ADDRESS,
SWITCH_INFO.PHYSICAL_SWITCH_WWN,
SWITCH_INFO.FIRMWARE_VERSION,
SWITCH_INFO.REACHABLE,
SWITCH_INFO.SYSLOG_REGISTERED,
SWITCH_INFO.SNMP_REGISTERED,
SWITCH_INFO.ID as VIRTUAL_SWITCH_ID,
SWITCH_INFO.NAME as VIRTUAL_SWITCH_NAME,
SWITCH_INFO.OPERATIONAL_STATUS,
SWITCH_INFO.SWITCH_MODE,
SWITCH_INFO.WWN as VIRTUAL_SWITCH_WWN,