Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

Brocade Network Advisor SAN User Manual 1161
53-1002167-01
Views
E
GIGE_PORT.SWITCH_PORT_ID = SWITCH_PORT.ID and
SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID;
GIGE_PORT_INFO
create or replace view GIGE_PORT_INFO as
select
GIGE_PORT.ID,
GIGE_PORT.SWITCH_PORT_ID,
GIGE_PORT.PORT_NUMBER,
GIGE_PORT.SLOT_NUMBER,
GIGE_PORT.ENABLED,
GIGE_PORT.SPEED,
GIGE_PORT.MAX_SPEED,
GIGE_PORT.MAC_ADDRESS,
GIGE_PORT.PORT_NAME,
GIGE_PORT.OPERATIONAL_STATUS,
GIGE_PORT.LED_STATE,
GIGE_PORT.SPEED_LED_STATE,
GIGE_PORT.PORT_TYPE,
GIGE_PORT.PERSISTENTLY_DISABLED,
GIGE_PORT.INTERFACE_TYPE,
GIGE_PORT.CHECKSUM,
GIGE_PORT.FCIP_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,
CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN
from
GIGE_PORT, SWITCH_PORT, CORE_SWITCH, 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;
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,