Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1855)

Brocade Network Advisor SAN User Manual 1803
53-1003154-01
Views
H
FABRIC_MEMBER DEST_FABRIC_MEMBER,
VIRTUAL_SWITCH DEST_VIRTUAL_SWITCH,
SWITCH_PORT DEST_SWITCH_PORT,
FABRIC
where
SOURCE_FABRIC_MEMBER.FABRIC_ID = ISL.FABRIC_ID and
SOURCE_VIRTUAL_SWITCH.ID = SOURCE_FABRIC_MEMBER.VIRTUAL_SWITCH_ID
and
SOURCE_VIRTUAL_SWITCH.DOMAIN_ID = ISL.SOURCE_DOMAIN_ID and
SOURCE_SWITCH_PORT.VIRTUAL_SWITCH_ID = SOURCE_VIRTUAL_SWITCH.ID and
SOURCE_SWITCH_PORT.CATEGORY = 1 and
SOURCE_SWITCH_PORT.USER_PORT_NUMBER = ISL.SOURCE_PORT_NUMBER and
DEST_FABRIC_MEMBER.FABRIC_ID = ISL.FABRIC_ID and
DEST_VIRTUAL_SWITCH.ID = DEST_FABRIC_MEMBER.VIRTUAL_SWITCH_ID and
DEST_VIRTUAL_SWITCH.DOMAIN_ID = ISL.DEST_DOMAIN_ID and
DEST_SWITCH_PORT.VIRTUAL_SWITCH_ID = DEST_VIRTUAL_SWITCH.ID and
DEST_SWITCH_PORT.CATEGORY = 1 and
DEST_SWITCH_PORT.USER_PORT_NUMBER = ISL.DEST_PORT_NUMBER and
FABRIC.ID = ISL.FABRIC_ID;
ISL_REPORT_INFO
CREATE OR REPLACE VIEW ISL_REPORT_INFO AS
SELECT ISL.ID, ISL.FABRIC_ID, ISL.COST, ISL.TYPE, ISL.TRUSTED,
ISL.CREATION_TIME, ISL.MISSING, ISL.MISSING_TIME, ISL.TRUNKED,
ISL.MISSING_REASON,
ISL.SOURCE_DOMAIN_ID, ISL.SOURCE_PORT_NUMBER,
SOURCE_VIRTUAL_SWITCH.ID AS SOURCE_SWITCH_ID,
SOURCE_VIRTUAL_SWITCH.NAME AS SOURCE_SWITCH_NAME,
SOURCE_VIRTUAL_SWITCH.WWN AS SOURCE_SWITCH_WWN,
SOURCE_VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID AS SOURCE_SWITCH_VIRTUAL_FABRIC_ID,
SOURCE_VIRTUAL_SWITCH.OPERATIONAL_STATUS AS SOURCE_SWITCH_OPERATIONAL_STATUS,
SOURCE_VIRTUAL_SWITCH.STATE AS SOURCE_SWITCH_STATE,
SOURCE_VIRTUAL_SWITCH.STATUS AS SOURCE_SWITCH_STATUS,
SOURCE_VIRTUAL_SWITCH.STATUS_REASON AS SOURCE_SWITCH_STATUS_REASON,
SOURCE_VIRTUAL_SWITCH.CORE_SWITCH_ID AS SOURCE_CORE_SWITCH_ID,
SOURCE_VIRTUAL_SWITCH.BASE_SWITCH AS SOURCE_BASE_SWITCH,
SOURCE_VIRTUAL_SWITCH.MANAGEMENT_STATE AS
SOURCE_VIRTUAL_SWITCH_MANAGEMENT_STATE,
SOURCE_VIRTUAL_SWITCH.MONITORED AS SOURCE_VIRTUAL_SWITCH_MONITORED,
SOURCE_CORE_SWITCH.IP_ADDRESS AS SOURCE_CORE_SWITCH_IP_ADDRESS,
SOURCE_CORE_SWITCH.WWN AS SOURCE_CORE_SWITCH_WWN,
SOURCE_CORE_SWITCH.NAME AS SOURCE_CORE_SWITCH_NAME,
SOURCE_CORE_SWITCH.TYPE AS SOURCE_CORE_SWITCH_TYPE,
SOURCE_CORE_SWITCH.OPERATIONAL_STATUS AS
SOURCE_CORE_SWITCH_OPERATIONAL_STATUS,
SOURCE_CORE_SWITCH.MODEL AS SOURCE_CORE_SWITCH_MODEL,
SOURCE_CORE_SWITCH.VENDOR AS SOURCE_CORE_SWITCH_VENDOR,
SOURCE_CORE_SWITCH.REACHABLE AS SOURCE_CORE_SWITCH_REACHABLE,
SOURCE_SWITCH_PORT.ID AS SOURCE_SWITCH_PORT_ID,
SOURCE_SWITCH_PORT.WWN AS SOURCE_SWITCH_PORT_WWN,
SOURCE_SWITCH_PORT.NAME AS SOURCE_SWITCH_PORT_NAME,
SOURCE_SWITCH_PORT.SLOT_NUMBER AS SOURCE_SWITCH_PORT_SLOT_NUMBER,
SOURCE_SWITCH_PORT.PORT_NUMBER AS SOURCE_SWITCH_PORT_PORT_NUMBER,
SOURCE_SWITCH_PORT.PORT_ID AS SOURCE_SWITCH_PORT_PORT_ID,
SOURCE_SWITCH_PORT.PORT_INDEX AS SOURCE_SWITCH_PORT_PORT_INDEX,
SOURCE_SWITCH_PORT.AREA_ID AS SOURCE_SWITCH_PORT_AREA_ID,
SOURCE_SWITCH_PORT.MAC_ADDRESS AS SOURCE_SWITCH_PORT_MAC_ADDRESS,
SOURCE_SWITCH_PORT.STATUS AS SOURCE_SWITCH_PORT_STATUS,