Brocade Communications Systems IP250 user manual L2NEIGHBORINFO, Mapseventdetailsinfo

I Views

VIRTUAL_SWITCH SOURCE_VIRTUAL_SWITCH, VIRTUAL_SWITCH DEST_VIRTUAL_SWITCH

where

ISL_INFO.SOURCE_SWITCH_ID = ISL_TRUNK_GROUP.VIRTUAL_SWITCH_ID

and ISL_INFO.SOURCE_PORT_NUMBER = ISL_TRUNK_GROUP.MASTER_USER_PORT and ISL_INFO.SOURCE_SWITCH_ID = SOURCE_VIRTUAL_SWITCH.ID

and SOURCE_VIRTUAL_SWITCH.CORE_SWITCH_ID = SOURCE_CORE_SWITCH.ID and ISL_INFO.DEST_SWITCH_ID = DEST_VIRTUAL_SWITCH.ID

and DEST_VIRTUAL_SWITCH.CORE_SWITCH_ID = DEST_CORE_SWITCH.ID;

L2_NEIGHBOR_INFO

create or replace view L2_NEIGHBOR_INFO as select

L2_NEIGHBOR.INTERFACE_ID,

L2_NEIGHBOR.RMT_IP_ADDRESS,

L2_NEIGHBOR.RMT_IF_NAME,

LLDP_DATA.DEVICE_ID as RMT_DEVICE_ID,

LLDP_DATA.INTERFACE_ID as RMT_INTERFACE_ID,

PHY_INTF.PHYSICAL_ADDRESS as RMT_INTERFACE_MAC,

RMT_DEVICE.IS_ROUTER from

device RMT_DEVICE, LLDP_DATA,

L2_NEIGHBOR,

physical_interface PHY_INTF where

LLDP_DATA.CHASSIS_ID = L2_NEIGHBOR.LLDP_REM_CHASSIS_ID

and LLDP_DATA.CHASSIS_ID_SUBTYPE = L2_NEIGHBOR.LLDP_REM_CHASSIS_ID_SUBTYPE and LLDP_DATA.PORT_ID = L2_NEIGHBOR.LLDP_REM_PORT_ID

and LLDP_DATA.PORT_ID_SUBTYPE = L2_NEIGHBOR.LLDP_REM_PORT_ID_SUBTYPE and LLDP_DATA.DEVICE_ID = RMT_DEVICE.device_id

and PHY_INTF.interface_id = LLDP_DATA.INTERFACE_ID;

MAPS_EVENT_DETAILS_INFO

CREATE OR REPLACE VIEW MAPS_EVENT_DETAILS_INFO AS

SELECT MAPS_EVENT.ID,

MAPS_EVENT.HOST_TIME,

MAPS_EVENT.CATEGORY,

MAPS_EVENT.VIOLATION_TYPE,

MAPS_EVENT.MANAGED_ELEMENT_ID,

MAPS_EVENT.ORIGIN_FABRIC_ID,

MAPS_EVENT.SWITCH_PORT_ID,

MAPS_EVENT.INTERFACE_ID,

MAPS_EVENT.FCIP_CIRCUIT_ID,

MAPS_EVENT.FRU_NAME,

MAPS_EVENT.VM_ID,

MAPS_EVENT.FLOW_DEFINITION_ID,

MAPS_EVENT_DETAILS.SWITCH_TIME,

MAPS_EVENT_DETAILS.RULE_NAME,

MAPS_EVENT_DETAILS.RULE_CONDITION,

MAPS_EVENT_DETAILS.TIME_BASE,

MAPS_EVENT_DETAILS.ACTIONS,

MAPS_EVENT_DETAILS.CURRENT_VALUE,

MAPS_EVENT_DETAILS.SWITCH_ENABLED_ACTIONS,

VIRTUAL_SWITCH.NAME AS SWITCH_NAME,

SWITCH_PORT.NAME AS SWITCH_PORT_NAME,

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