Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2297)

2260 Brocade Network Advisor SAN + IP User Manual
53-1002949-01
Views
I
from
DEVICE_PORT_GIGE_PORT_LINK,
DEVICE_PORT
where
DEVICE_PORT_GIGE_PORT_LINK.DEVICE_PORT_ID = DEVICE_PORT.ID;
DEV_PORT_MAC_ADDR_MAP_INFO
create or replace view DEV_PORT_MAC_ADDR_MAP_INFO as
select
DEVICE_PORT_MAC_ADDRESS_MAP.DEVICE_PORT_ID,
DEVICE_PORT_MAC_ADDRESS_MAP.MAC_ADDRESS,
DEVICE_NODE.ID as DEVICE_NODE_ID,
DEVICE_NODE.FABRIC_ID,
DEVICE_PORT.TRUSTED,
DEVICE_PORT.CREATION_TIME,
DEVICE_PORT.MISSING,
DEVICE_PORT.MISSING_TIME
from
DEVICE_PORT_MAC_ADDRESS_MAP,
DEVICE_PORT,
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;