Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

Brocade Network Advisor SAN User Manual 1403
53-1002696-01
Views
H
CORE_SWITCH_DETAILS.SW_LICENSE_ID,
CORE_SWITCH_DETAILS.SUPPLIER_SERIAL_NUMBER,
CORE_SWITCH_DETAILS.PART_NUMBER,
CORE_SWITCH_DETAILS.CHECK_BEACON,
CORE_SWITCH_DETAILS.TIMEZONE,
CORE_SWITCH_DETAILS.MAX_PORT,
CORE_SWITCH_DETAILS.CHASSIS_SERVICE_TAG,
CORE_SWITCH_DETAILS.BAY_ID,
CORE_SWITCH_DETAILS.TYPE_NUMBER,
CORE_SWITCH_DETAILS.MODEL_NUMBER,
CORE_SWITCH_DETAILS.MANUFACTURER,
CORE_SWITCH_DETAILS.PLANT_OF_MANUFACTURER,
CORE_SWITCH_DETAILS.SWITCH_SERIAL_NUMBER,
CORE_SWITCH_DETAILS.ACT_CP_PRI_FW_VERSION,
CORE_SWITCH_DETAILS.ACT_CP_SEC_FW_VERSION,
CORE_SWITCH_DETAILS.STBY_CP_PRI_FW_VERSION,
CORE_SWITCH_DETAILS.STBY_CP_SEC_FW_VERSION,
CORE_SWITCH_DETAILS.TYPE as DETAILS_TYPE,
CORE_SWITCH_DETAILS.EGM_CAPABLE,
CORE_SWITCH_DETAILS.SUB_TYPE,
CORE_SWITCH_DETAILS.PARTITION,
CORE_SWITCH_DETAILS.MAX_NUM_OF_BLADES,
CORE_SWITCH_DETAILS.SNMP_INFORMS_ENABLED,
CORE_SWITCH_DETAILS.VENDOR_VERSION,
CORE_SWITCH_DETAILS.VENDOR_PART_NUMBER,
CORE_SWITCH_DETAILS.CONTACT,
CORE_SWITCH_DETAILS.LOCATION,
CORE_SWITCH_DETAILS.DESCRIPTION,
CORE_SWITCH_DETAILS.RNID_SEQUENCE_NUMBER,
CORE_SWITCH_DETAILS.FIRMWARE_VERSION as CSD_FIRMWARE_VERSION,
CORE_SWITCH_DETAILS.CHASSIS_PACKAGE_TYPE,
CORE_SWITCH_DETAILS.IP_ADDRESS_PREFIX,
CORE_SWITCH_DETAILS.DOMAIN_NAME,
CORE_SWITCH_DETAILS.FRAME_LOG_SIZE,
CORE_SWITCH_DETAILS.FRAME_LOG_ENABLED,
CORE_SWITCH_DETAILS.MAPS_ENABLED
from
CORE_SWITCH,
VIRTUAL_SWITCH,
FABRIC_MEMBER,
CORE_SWITCH_DETAILS
where
VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID
and FABRIC_MEMBER.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID
and CORE_SWITCH_DETAILS.CORE_SWITCH_ID = CORE_SWITCH.ID;
SWITCH_DISCOVERED_MAC_INFO
create or replace view SWITCH_DISCOVERED_MAC_INFO as
select
L2_NEIGHBOR.LLDP_REM_CHASSIS_ID_VALUE,
L2_NEIGHBOR.INTERFACE_ID,
INTERFACE.NAME as INTERFACE_NAME,
DEVICE.SYS_NAME as DEVICE_NAME,
DEVICE.IP_ADDRESS, DEVICE.DEVICE_ID
from
L2_NEIGHBOR,
INTERFACE,
DEVICE