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

Brocade Network Advisor SAN User Manual 1779
53-1003154-01
Views
H
and DEVICE_PORT.NODE_ID = DEVICE_NODE.ID;
ISL_CONNECTION_INFO
create or replace view ISL_CONNECTION_INFO as
select
distinct ISL_CONNECTION.ID,
ISL_CONNECTION.FABRIC_ID,
ISL_CONNECTION.SOURCE_SWITCH_PORT_ID,
ISL_CONNECTION.TARGET_SWITCH_PORT_ID,
ISL_CONNECTION.COST,
ISL_CONNECTION.TYPE,
ISL_CONNECTION.TRUSTED,
ISL_CONNECTION.MISSING,
ISL_CONNECTION.MISSING_TIME,
ISL_CONNECTION.CREATION_TIME,
ISL_CONNECTION.TRUNKED,
ISL_CONNECTION.MISSING_REASON,
ISL_CONNECTION.MASTER_CONNECTION_ID,
ISL_CONNECTION.SOURCE_MASTER_PORT AS SOURCE_MASTER_PORT_NUMBER,
ISL_CONNECTION.TARGET_MASTER_PORT AS DEST_MASTER_PORT_NUMBER,
ISL_CONNECTION.SOURCE_PORT_SPEED AS SOURCE_PORT_SPEED,
ISL_CONNECTION.TARGET_PORT_SPEED AS DEST_PORT_SPEED,
SOURCE_SWITCH_PORT.VIRTUAL_SWITCH_ID as SOURCE_SWITCH_ID,
SOURCE_SWITCH_PORT.USER_PORT_NUMBER as SOURCE_SWITCH_PORT_NUMBER,
DEST_SWITCH_PORT.VIRTUAL_SWITCH_ID as DEST_SWITCH_ID,
DEST_SWITCH_PORT.USER_PORT_NUMBER as DEST_SWITCH_PORT_NUMBER,
COALESCE(ISL_TRUNK_GROUP.MEMBER_TRACKING_STATUS, -1) AS MEMBER_TRACKING_STATUS
COALESCE(ISL_TRUNK_GROUP.ID, (-1)) AS TRUNK_ID
from
ISL_CONNECTION
LEFT JOIN SWITCH_PORT SOURCE_SWITCH_PORT ON (ISL_CONNECTION.SOURCE_SWITCH_PORT_ID
= SOURCE_SWITCH_PORT.ID)
LEFT JOIN SWITCH_PORT DEST_SWITCH_PORT ON (ISL_CONNECTION.TARGET_SWITCH_PORT_ID =
DEST_SWITCH_PORT.ID)
LEFT JOIN ISL_TRUNK_GROUP ON (ISL_CONNECTION.TRUNKED = 1
AND ISL_TRUNK_GROUP.MASTER_USER_PORT = ISL_CONNECTION.SOURCE_MASTER_PORT
AND ISL_TRUNK_GROUP.VIRTUAL_SWITCH_ID =
SOURCE_SWITCH_PORT.VIRTUAL_SWITCH_ID );
ISL_INFO
create or replace view ISL_INFO as
select distinct
ISL.ID,
ISL.FABRIC_ID,
ISL.COST,
ISL.TYPE,
ISL.SOURCE_DOMAIN_ID,
ISL.SOURCE_PORT_NUMBER,
ISL.MISSING,
ISL.MISSING_TIME,
ISL.TRUSTED,
ISL.CREATION_TIME,
ISL.TRUNKED,