Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

1528 Brocade Network Advisor SAN User Manual
53-1002948-01
Views
H
DEVICE_NODE
where
DEVICE_PORT_MAC_ADDRESS_MAP.DEVICE_PORT_ID = DEVICE_PORT.ID
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,
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
from
ISL_CONNECTION,
SWITCH_PORT SOURCE_SWITCH_PORT,
SWITCH_PORT DEST_SWITCH_PORT
where
ISL_CONNECTION.SOURCE_SWITCH_PORT_ID = SOURCE_SWITCH_PORT.ID
and ISL_CONNECTION.TARGET_SWITCH_PORT_ID = DEST_SWITCH_PORT.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,
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.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,