Views I

CNA_PORT.NAME,

CNA_PORT.MAC_ADDRESS, CNA_PORT.MEDIA, CNA_PORT.CEE_STATE, CNA_PORT.HBA_ID,

CNA_PORT.CREATION_TIME as CNA_PORT_CREATION_TIME, CNA_ETH_PORT.ID as ETH_PORT_ID, CNA_ETH_PORT.ETH_DEV, CNA_ETH_PORT.ETH_LOG_LEVEL, CNA_ETH_PORT.NAME as ETH_PORT_NAME, CNA_ETH_PORT.MAC_ADDRESS as ETH_MAC_ADDRESS, CNA_ETH_PORT.IOC_ID,

CNA_ETH_PORT.HARDWARE_PATH, CNA_ETH_PORT.STATUS,

CNA_ETH_PORT.CREATION_TIME as ETH_PORT_CREATION_TIME, CNA_ETH_PORT.CURRENT_MAC_ADDRESS as CURRENT_MAC_ADDRESS, CNA_ETH_PORT.MAX_BANDWIDTH, CNA_ETH_PORT.PCIF_INDEX,

CNA_ETH_PORT.MAX_PCIF,

CNA_ETH_PORT.MIN_BANDWIDTH, CNA_ETH_PORT.MTU,

CNA_PORT.ALARM_WARNING

from

CNA_PORT

left outer join CNA_ETH_PORT on CNA_PORT.ID = CNA_ETH_PORT.CNA_PORT_ID;

CNA_PORT_INFO

create or replace view CNA_PORT_INFO as select

CNA_PORT.ID,

CNA_PORT.PORT_NUMBER, CNA_PORT.PORT_WWN, CNA_PORT.NODE_WWN,

CNA_PORT.PHYSICAL_PORT_TYPE, CNA_PORT.NAME, CNA_PORT.MAC_ADDRESS, CNA_PORT.MEDIA, CNA_PORT.CEE_STATE, CNA_PORT.HBA_ID,

CNA_PORT.CREATION_TIME as CNA_PORT_CREATION_TIME, CNA_ETH_PORT.ID as ETH_PORT_ID, CNA_ETH_PORT.ETH_DEV, CNA_ETH_PORT.ETH_LOG_LEVEL, CNA_ETH_PORT.NAME as ETH_PORT_NAME, CNA_ETH_PORT.MAC_ADDRESS as ETH_MAC_ADDRESS, CNA_ETH_PORT.IOC_ID,

CNA_ETH_PORT.HARDWARE_PATH, CNA_ETH_PORT.STATUS,

CNA_ETH_PORT.CREATION_TIME as ETH_PORT_CREATION_TIME, HBA_PORT.DEVICE_PORT_ID,

CNA_ETH_PORT.MTU,

CNA_PORT.ALARM_WARNING

from

CNA_PORT

left outer join HBA_PORT on CNA_PORT.ID = HBA_PORT.CNA_PORT_ID

left outer join CNA_ETH_PORT on CNA_PORT.ID = CNA_ETH_PORT.CNA_PORT_ID;

Brocade Network Advisor IP User Manual

1603

53-1003056-01

 

Page 1655
Image 1655
Brocade Communications Systems IP250 user manual Cnaportinfo, Cnaethport.Hardwarepath, Cnaethport.Status