Brocade Network Advisor IP User Manual v12.1.0 - Manual (Page 1695)

Brocade Network Advisor IP User Manual 1641
53-1002947-01
Views
I
where
GIGE_PORT_ETHERNET_CLOUD_LINK.SWITCH_PORT_ID = GIGE_PORT.ID and
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,
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,