Brocade Communications Systems IP250 user manual Bootimagefiledetailsinfo, Cnaethportconfiginfo

I Views

BOOT_IMAGE_FILE_DETAILS_INFO

create or replace view BOOT_IMAGE_FILE_DETAILS_INFO as select

BOOT_IMAGE_FILE_DETAILS.BOOT_IMAGE_NAME, BOOT_IMAGE_FILE_DETAILS.MAJOR_VERSION, BOOT_IMAGE_FILE_DETAILS.MINOR_VERSION, BOOT_IMAGE_FILE_DETAILS.MAINTENANCE, BOOT_IMAGE_FILE_DETAILS.PATCH, BOOT_IMAGE_FILE_DETAILS.IMPORTED_DATE, BOOT_IMAGE_FILE_DETAILS.RELEASE_DATE, BOOT_IMAGE_FILE_DETAILS.RELEASE_NOTES_LOCATION, BOOT_IMAGE_FILE_DETAILS.LOCATION, 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,

1602	Brocade Network Advisor IP User Manual
	53-1003056-01