Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2333)

2296 Brocade Network Advisor SAN + IP User Manual
53-1002949-01
Views
I
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
where
L2_NEIGHBOR.LLDP_REM_CHASSIS_ID_SUBTYPE = 4
and L2_NEIGHBOR.INTERFACE_ID = INTERFACE.INTERFACE_ID
and INTERFACE.DEVICE_ID = DEVICE.DEVICE_ID;
SWITCH_PORT_INFO
CREATE VIEW switch_port_info AS
select
SWITCH_PORT.ID,
SWITCH_PORT.VIRTUAL_SWITCH_ID,
SWITCH_PORT.WWN,
SWITCH_PORT.NAME,
SWITCH_PORT.SLOT_NUMBER,
SWITCH_PORT.PORT_NUMBER,
SWITCH_PORT.USER_PORT_NUMBER,
SWITCH_PORT.PORT_ID,
SWITCH_PORT.PORT_INDEX,