Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Brocade Network Advisor SAN User Manual 1537
53-1002948-01
Views
H
GIGE_PORT.INTERFACE_TYPE,
GIGE_PORT.CHECKSUM,
GIGE_PORT.FCIP_CAPABLE,
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,