Views I

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,

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, SWITCH_PORT.SPEED_TYPE, 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,

Brocade Network Advisor IP User Manual

1627

53-1003056-01

 

Page 1679
Image 1679
Brocade Communications Systems IP250 user manual Gigeportinfo, Hbaportdetailsinfo, Gigeport Switchport Coreswitch