Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

Brocade Network Advisor SAN User Manual 1381
53-1002696-01
Views
H
coalesce(CARD.FCIP_CIRCUIT_CAPABLE, VIRTUAL_SWITCH.FCIP_CIRCUIT_CAPABLE) as
FCIP_CIRCUIT_CAPABLE,
GIGE_PORT.ISCSI_CAPABLE,
GIGE_PORT.REMOTE_MAC_ADDRESS,
GIGE_PORT.INBAND_MANAGEMENT_STATUS,
GIGE_PORT.LAST_UPDATE,
SWITCH_PORT.VIRTUAL_SWITCH_ID,
SWITCH_PORT.USER_PORT_NUMBER,
SWITCH_PORT.PORT_INDEX,
VIRTUAL_SWITCH.WWN as VIRTUAL_SWITCH_WWN,
VIRTUAL_SWITCH.MANAGEMENT_STATE,
VIRTUAL_SWITCH.MONITORED,
CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN
from
GIGE_PORT,
SWITCH_PORT,
CORE_SWITCH
left outer join CARD on CORE_SWITCH.ID = CARD.CORE_SWITCH_ID,
VIRTUAL_SWITCH
where
GIGE_PORT.SWITCH_PORT_ID = SWITCH_PORT.ID and
SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID and
VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID and
GIGE_PORT.SLOT_NUMBER in (0, CARD.SLOT_NUMBER);
HBA_PORT_DETAILS_INFO
create or replace view HBA_PORT_DETAILS_INFO as
select
HBA_PORT.DEVICE_PORT_ID,
HBA_PORT.CONFIGURED_STATE,
HBA_PORT.CONFIGURED_SPEED,
HBA_PORT.CONFIGURED_TOPOLOGY,
HBA_PORT.MAX_SPEED_SUPPORTED,
HBA_PORT.OPERATING_STATE,
HBA_PORT.OPERATING_TOPOLOGY,
HBA_PORT.SUPPORTED_FC4_TYPES,
HBA_PORT.SUPPORTED_COS,
HBA_PORT.TRUSTED as HBA_PORT_TRUSTED,
HBA_PORT.CREATION_TIME as HBA_PORT_CREATION_TIME,
HBA_PORT.MISSING as HBA_PORT_MISSING,
HBA_PORT.MISSING_TIME as HBA_PORT_MISSING_TIME,
HBA_PORT.OPERATING_SPEED,
HBA_PORT.CNA_PORT_ID,
HBA_PORT.PORT_NWWN,
HBA_PORT.PHYSICAL_PORT_WWN,
HBA_PORT.SWITCH_IP,
HBA_PORT.PRINCIPAL_SWITCH_WWN,
HBA_PORT.HBA_ID,
HBA_PORT.PORT_NUMBER,
HBA_PORT.NAME,
HBA_PORT.FACTORY_PORT_WWN,
HBA_PORT.FACTORY_NODE_WWN,
HBA_PORT.PREBOOT_CREATED,
HBA_PORT.MAX_BANDWIDTH,
HBA_PORT.PCIF_INDEX,
HBA_PORT.MAX_PCIF,
HBA_PORT_DETAIL.PERSISTENT_BINDING,
HBA_PORT_DETAIL.FABRIC_NAME,