Brocade Network Advisor Documentation Updates v11.1.x (53-1002363-03, August 2011)

180 Brocade Network Advisor Documentation Updates
53-1002363-02
Views
E
DEV_PORT_GIGE_PORT_LINK_INFO
create or replace view DEV_PORT_GIGE_PORT_LINK_INFO as
select
DEVICE_PORT_GIGE_PORT_LINK.DEVICE_PORT_ID,
DEVICE_PORT_GIGE_PORT_LINK.GIGE_PORT_ID,
DEVICE_PORT_GIGE_PORT_LINK.DIRECT_ATTACH,
DEVICE_PORT.TRUSTED,
DEVICE_PORT.CREATION_TIME,
DEVICE_PORT.MISSING,
DEVICE_PORT.MISSING_TIME
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;
ETHERNET_ISL_INFO
create or replace view ETHERNET_ISL_INFO as
select
ETHERNET_ISL.ID as ETHERNET_ISL_ID,
ETHERNET_ISL.SOURCE_PORT_ID,
ETHERNET_ISL.DEST_PORT_ID,
ETHERNET_ISL.TRUSTED,
ETHERNET_ISL.CREATION_TIME,
ETHERNET_ISL.MISSING,
ETHERNET_ISL.MISSING_TIME,
SOURCE_SWITCH_PORT.VIRTUAL_SWITCH_ID as SOURCE_SWITCH_ID,
SOURCE_SWITCH_PORT.USER_PORT_NUMBER as SOURCE_PORT_NUMBER,
SOURCE_SWITCH_PORT.TYPE as SOURCE_PORT_TYPE,
SOURCE_VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID as SOURCE_VIRTUAL_FABRIC_ID,
DEST_SWITCH_PORT.VIRTUAL_SWITCH_ID as DEST_SWITCH_ID,
DEST_SWITCH_PORT.USER_PORT_NUMBER as DEST_PORT_NUMBER,
DEST_SWITCH_PORT.TYPE as DEST_PORT_TYPE,
DEST_VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID as DEST_VIRTUAL_FABRIC_ID
from