Brocade Network Advisor IP User Manual 1603
53-1003056-01
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;