Brocade Communications Systems Network Advisor 12.0.0, User Manual

Page: 1437 / 1505

Brocade Network Advisor SAN User Manual 1389
53-1002696-01
Views
H
ISL_TRUNK_GROUP.ID,
ISL_INFO.COST,
ISL_INFO.TYPE,
ISL_INFO.SOURCE_PORT_NUMBER,
ISL_INFO.SOURCE_SWITCH_ID,
SOURCE_CORE_SWITCH.IP_ADDRESS as SOURCE_SWITCH_IP_ADDRESS,
SOURCE_VIRTUAL_SWITCH.WWN as SOURCE_SWITCH_WWN,
SOURCE_VIRTUAL_SWITCH.MANAGEMENT_STATE as SOURCE_SWITCH_MANAGEMENT_STATE,
SOURCE_VIRTUAL_SWITCH.MONITORED as SOURCE_SWITCH_MONITORED,
ISL_INFO.SOURCE_DOMAIN_ID as MASTER_PORT,
ISL_INFO.SOURCE_SWITCH_NAME,
ISL_INFO.SOURCE_SWITCH_PORT_ID,
ISL_INFO.DEST_PORT_NUMBER,
ISL_INFO.DEST_SWITCH_ID,
DEST_CORE_SWITCH.IP_ADDRESS as DEST_SWITCH_IP_ADDRESS,
DEST_VIRTUAL_SWITCH.WWN as DEST_SWITCH_WWN,
DEST_VIRTUAL_SWITCH.MANAGEMENT_STATE as DEST_SWITCH_MANAGEMENT_STATE,
DEST_VIRTUAL_SWITCH.MONITORED as DEST_SWITCH_MONITORED,
ISL_INFO.SOURCE_SWITCH_PORT_WWN,
ISL_INFO.DEST_DOMAIN_ID as REMOTE_MASTER_PORT,
ISL_INFO.DEST_SWITCH_NAME,
ISL_INFO.DEST_SWITCH_PORT_ID
from
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