Brocade Communications Systems Network Advisor 12.3.0, User Manual

Page: 1857 / 1940

Brocade Network Advisor SAN User Manual 1805
53-1003154-01
Views
H
FABRIC.PRINCIPAL_SWITCH_WWN AS FABRIC_PRINCIPAL_SWITCH_WWN,
FABRIC.MANAGEMENT_STATE AS FABRIC_MANAGEMENT_STATE, FABRIC.TYPE AS FABRIC_TYPE,
FABRIC.MANAGED AS FABRIC_MANAGED
FROM ISL
LEFT JOIN FABRIC_MEMBER SOURCE_FABRIC_MEMBER ON SOURCE_FABRIC_MEMBER.FABRIC_ID =
ISL.FABRIC_ID JOIN VIRTUAL_SWITCH SOURCE_VIRTUAL_SWITCH ON
SOURCE_VIRTUAL_SWITCH.ID = SOURCE_FABRIC_MEMBER.VIRTUAL_SWITCH_ID AND
SOURCE_VIRTUAL_SWITCH.DOMAIN_ID = ISL.SOURCE_DOMAIN_ID
JOIN CORE_SWITCH SOURCE_CORE_SWITCH ON SOURCE_CORE_SWITCH.ID =
SOURCE_VIRTUAL_SWITCH.CORE_SWITCH_ID
LEFT JOIN SWITCH_PORT SOURCE_SWITCH_PORT ON SOURCE_SWITCH_PORT.VIRTUAL_SWITCH_ID
= SOURCE_VIRTUAL_SWITCH.ID AND SOURCE_SWITCH_PORT.USER_PORT_NUMBER =
ISL.SOURCE_PORT_NUMBER
LEFT JOIN FABRIC_MEMBER DEST_FABRIC_MEMBER ON DEST_FABRIC_MEMBER.FABRIC_ID =
ISL.FABRIC_ID JOIN VIRTUAL_SWITCH DEST_VIRTUAL_SWITCH ON DEST_VIRTUAL_SWITCH.ID =
DEST_FABRIC_MEMBER.VIRTUAL_SWITCH_ID AND DEST_VIRTUAL_SWITCH.DOMAIN_ID =
ISL.DEST_DOMAIN_ID
JOIN CORE_SWITCH DEST_CORE_SWITCH ON DEST_CORE_SWITCH.ID =
DEST_VIRTUAL_SWITCH.CORE_SWITCH_ID
LEFT JOIN SWITCH_PORT DEST_SWITCH_PORT ON DEST_SWITCH_PORT.VIRTUAL_SWITCH_ID =
DEST_VIRTUAL_SWITCH.ID AND DEST_SWITCH_PORT.USER_PORT_NUMBER =
ISL.DEST_PORT_NUMBER
JOIN FABRIC ON FABRIC.ID = ISL.FABRIC_ID
WHERE SOURCE_VIRTUAL_SWITCH.MONITORED = 1 AND SOURCE_CORE_SWITCH.TYPE NOT IN
(40,41) AND (SOURCE_SWITCH_PORT.CATEGORY IS NULL OR SOURCE_SWITCH_PORT.CATEGORY =
1)
AND DEST_VIRTUAL_SWITCH.MONITORED = 1 AND DEST_CORE_SWITCH.TYPE NOT IN (40,41) AND
(DEST_SWITCH_PORT.CATEGORY IS NULL OR DEST_SWITCH_PORT.CATEGORY = 1)
AND FABRIC.MANAGED = 1 AND FABRIC.TYPE NOT IN (65,66,4);
ISL_TRILL_INFO
create or replace view ISL_TRILL_INFO as
select distinct
VCS_DEVICE.DEVICE_ID as VCS_DEVICE_ID,
SOURCE_CLUSTER_MEMBER.CLUSTER_ME_ID,
ISL.ID,
ISL.FABRIC_ID,
ISL.COST,
ISL.MISSING,
ISL.SOURCE_DOMAIN_ID,
ISL.SOURCE_PORT_NUMBER,
SOURCE_DEVICE.MANAGED_ELEMENT_ID as SOURCE_ME_ID,
SOURCE_DEVICE.DEVICE_ID as SOURCE_DEVICE_ID,
SOURCE_DEVICE.SYS_NAME as SOURCE_DEVICE_NAME,
SOURCE_SWITCH_PORT.ID as SOURCE_SWITCH_PORT_ID,
SOURCE_SWITCH_PORT.NAME as SOURCE_SWITCH_PORT_NAME,
SOURCE_SWITCH_PORT.IDENTIFIER as SOURCE_SWITCH_PORT_IDENTIFIER,
SOURCE_SWITCH_PORT.TYPE as PORT_TYPE,
SOURCE_SWITCH_PORT.KIND as SOURCE_SWITCH_PORT_KIND,
SOURCE_SWITCH_PORT.PHYSICAL_PORT as SOURCE_PHYSICAL_PORT,
SOURCE_SWITCH_PORT.TRUNKED as SOURCE_SWITCH_PORT_TRUNKED,
ISL.DEST_DOMAIN_ID,
ISL.DEST_PORT_NUMBER,
DEST_DEVICE.DEVICE_ID as DEST_DEVICE_ID,
DEST_DEVICE.MANAGED_ELEMENT_ID AS DEST_ME_ID,
DEST_DEVICE.SYS_NAME as DEST_DEVICE_NAME,
DEST_SWITCH_PORT.ID as DEST_SWITCH_PORT_ID,
DEST_SWITCH_PORT.NAME as DEST_SWITCH_PORT_NAME,