Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

1512 Brocade Network Advisor SAN User Manual
53-1002948-01
Views
H
BOOT_IMAGE_DRIVER_MAP.SUPPORTED_DRIVERS
from
BOOT_IMAGE_FILE_DETAILS,
BOOT_IMAGE_DRIVER_MAP
where
BOOT_IMAGE_FILE_DETAILS.DRIVER_MAPPING_ID= BOOT_IMAGE_DRIVER_MAP.ID;
CNA_ETH_PORT_CONFIG_INFO
create or replace view CNA_ETH_PORT_CONFIG_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_ETH_PORT_CONFIG.CNA_ETH_PORT_ID as CNA_ETH_PORT_ID,
CNA_ETH_PORT_CONFIG.ID as CNA_ETH_PORT_CONFIG_ID,
CNA_ETH_PORT_CONFIG.CURRENT_MAC_ADDRESS,
CNA_ETH_PORT_CONFIG.MAX_BANDWIDTH,
CNA_ETH_PORT_CONFIG.PCIF_INDEX,
CNA_ETH_PORT_CONFIG.MIN_BANDWIDTH,
CNA_ETH_PORT_CONFIG.PORT_NUMBER as ETH_PORT_CONFIG_PORT_NUMBER,
CNA_ETH_PORT_CONFIG.PORT_TYPE,
CNA_ETH_PORT_CONFIG.CONFIGURATION_STATUS
from
CNA_PORT
left outer join CNA_ETH_PORT_CONFIG on CNA_PORT.ID =
CNA_ETH_PORT_CONFIG.CNA_PORT_ID;
CNA_PORT_DETAILS_INFO
create or replace view CNA_PORT_DETAILS_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,