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

2278 Brocade Network Advisor SAN + IP User Manual
53-1002949-01
Views
I
ISL_TRUNK_GROUP,
ISL_INFO,
CORE_SWITCH SOURCE_CORE_SWITCH,
CORE_SWITCH DEST_CORE_SWITCH,
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.FCIP_CIRCUIT_ID,
MAPS_EVENT.FRU_NAME,
MAPS_EVENT.VM_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,