Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1877)

Brocade Network Advisor SAN User Manual 1825
53-1003154-01
Views
H
SWITCH_CONFIG. IS_BASELINE,
SWITCH_CONFIG. BACKUP_TYPE,
SWITCH_CONFIG. DRIFT_STATUS,
SWITCH_CONFIG_DETAIL.IP_ADDRESS,
SWITCH_CONFIG_DETAIL.WWN,
SWITCH_CONFIG_DETAIL.PHYSICAL_SWITCH_WWN,
SWITCH_CONFIG_DETAIL.MODEL_NUMBER as SWITCH_MODEL_NUMBER
from
SWITCH_CONFIG,
SWITCH_CONFIG_DETAIL
where
SWITCH_CONFIG.ID= SWITCH_CONFIG_DETAIL.SWITCH_CONFIG_ID;
SWITCH_PORT_DETAILS_INFO
create or replace view SWITCH_PORT_DETAILS_REPORT_INFO as
with SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW as (
select SWITCH_PORT.ID as REMOTE_SWITCH_PORT_ID,
SWITCH_PORT.VIRTUAL_SWITCH_ID as REMOTE_VIRTUAL_SWITCH_ID,
SWITCH_PORT.SLOT_NUMBER as REMOTE_PORT_SLOT_NUMBER,
SWITCH_PORT.PORT_NUMBER as REMOTE_PORT_NUMBER,
SWITCH_PORT.USER_PORT_NUMBER as REMOTE_USER_PORT_NUMBER,
SWITCH_PORT.NAME as REMOTE_PORT_NAME,
SWITCH_PORT.SPEED as REMOTE_PORT_SPEED,
SWITCH_PORT.STATUS as REMOTE_PORT_STATUS,
SWITCH_PORT.STATE as REMOTE_PORT_STATE,
SWITCH_PORT.TYPE as REMOTE_PORT_TYPE,
SWITCH_PORT.SPEEDS_SUPPORTED as REMOTE_PORT_SPEEDS_SUPPORTED,
SWITCH_PORT.PHYSICAL_PORT as REMOTE_PHYSICAL_OR_LOGICAL_PORT,
SWITCH_PORT.PORT_INDEX as REMOTE_ZONING_PORT_INDEX,
SWITCH_PORT.PORT_ID as REMOTE_PORT_ID,
SWITCH_PORT.WWN as REMOTE_SWITCH_PORT_WWN,
SWITCH_PORT.AREA_ID as REMOTE_PORT_AREA_ID,
SWITCH_PORT.MAC_ADDRESS as REMOTE_PORT_MAC_ADDRESS,
SWITCH_PORT.PORT_MOD as REMOTE_PORT_MOD,
SWITCH_PORT.FULL_TYPE as REMOTE_PORT_FULL_TYPE,
SWITCH_PORT.HEALTH as REMOTE_PORT_HEALTH,
SWITCH_PORT.STATUS_MESSAGE as REMOTE_SWITCH_PORT_STATUS_MESSAGE,
SWITCH_PORT.MAX_PORT_SPEED as REMOTE_PORT_MAX_PORT_SPEED,
SWITCH_PORT.LICENSED as REMOTE_PORT_LICENSED,
SWITCH_PORT.REMOTE_NODE_WWN as REMOTE_REMOTE_NODE_WWN,
SWITCH_PORT.REMOTE_PORT_WWN as REMOTE_REMOTE_PORT_WWN,
SWITCH_PORT.TRUNKED as REMOTE_PORT_TRUNKED,
SWITCH_PORT.TRUNK_MASTER as REMOTE_PORT_TRUNK_MASTER,
SWITCH_PORT.FICON_SUPPORTED as REMOTE_PORT_FICON_SUPPORTED,
SWITCH_PORT.BLOCKED as REMOTE_PORT_BLOCKED,
SWITCH_PORT.NPIV as REMOTE_PORT_NPIV,
SWITCH_PORT.NPIV_CAPABLE as REMOTE_PORT_NPIV_CAPABLE,
SWITCH_PORT.NPIV_ENABLED as REMOTE_PORT_NPIV_ENABLED,
SWITCH_PORT.QOS_CAPABLE as REMOTE_PORT_QOS_CAPABLE,
SWITCH_PORT.QOS_ENABLED as REMOTE_PORT_QOS_ENABLED,
SWITCH_PORT.TUNNEL_CONFIGURED as REMOTE_PORT_TUNNEL_CONFIGURED,
SWITCH_PORT.FCR_FABRIC_ID as REMOTE_FCR_FABRIC_ID,
SWITCH_PORT.FCR_INTEROP_MODE as REMOTE_PORT_FCR_INTEROP_MODE,
SWITCH_PORT.USER_DEFINED_VALUE1 as REMOTE_PORT_USER_DEFINED_VALUE1,
SWITCH_PORT.USER_DEFINED_VALUE2 as REMOTE_PORT_USER_DEFINED_VALUE2,
SWITCH_PORT.USER_DEFINED_VALUE3 as REMOTE_PORT_USER_DEFINED_VALUE3,
SWITCH_PORT.KIND as REMOTE_PORT_KIND,
SWITCH_PORT.LAST_UPDATE as REMOTE_PORT_LAST_UPDATE,