Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1410 Brocade Network Advisor SAN User Manual
53-1002696-01
Views
H
VCS_DEVICE.DEVICE_ID as VCS_DEVICE_ID,
TRILL.CLUSTER_ME_ID,
TRILL.COST,
TRILL.MISSING,
TRILL.TRUNKED,
TRILL.SOURCE_DOMAIN_ID,
TRILL.SOURCE_PORT_NUMBER,
TRILL.SOURCE_ME_ID,
TRILL.SOURCE_SWITCH_PORT_ID,
SOURCE_DEVICE.DEVICE_ID AS SOURCE_DEVICE_ID,
SOURCE_SWITCH_PORT.TYPE as PORT_TYPE,
SOURCE_SWITCH_PORT.NAME as SOURCE_SWITCH_PORT_NAME,
SOURCE_SWITCH_PORT.KIND as SOURCE_SWITCH_PORT_KIND,
SOURCE_SWITCH_PORT.PHYSICAL_PORT as SOURCE_PHYSICAL_PORT,
TRILL.DEST_DOMAIN_ID,
TRILL.DEST_PORT_NUMBER,
TRILL.DEST_ME_ID,
TRILL.DEST_SWITCH_PORT_ID,
DEST_DEVICE.DEVICE_ID AS DEST_DEVICE_ID,
DEST_SWITCH_PORT.NAME as DEST_SWITCH_PORT_NAME,
DEST_SWITCH_PORT.KIND as DEST_SWITCH_PORT_KIND,
DEST_SWITCH_PORT.PHYSICAL_PORT as DEST_PHYSICAL_PORT
from
TRILL,
DEVICE VCS_DEVICE,
DEVICE SOURCE_DEVICE,
SWITCH_PORT SOURCE_SWITCH_PORT,
VIRTUAL_SWITCH SOURCE_VIRTUAL_SWITCH,
DEVICE DEST_DEVICE,
SWITCH_PORT DEST_SWITCH_PORT,
VIRTUAL_SWITCH DEST_VIRTUAL_SWITCH
where
SOURCE_DEVICE.MANAGED_ELEMENT_ID = TRILL.SOURCE_ME_ID and
DEST_DEVICE.MANAGED_ELEMENT_ID = TRILL.DEST_ME_ID and
VCS_DEVICE.MANAGED_ELEMENT_ID = TRILL.CLUSTER_ME_ID and
SOURCE_VIRTUAL_SWITCH.MANAGED_ELEMENT_ID = TRILL.SOURCE_ME_ID and
SOURCE_SWITCH_PORT.VIRTUAL_SWITCH_ID = SOURCE_VIRTUAL_SWITCH.ID and
SOURCE_SWITCH_PORT.NAME = TRILL.SOURCE_PORT_NUMBER and
DEST_VIRTUAL_SWITCH.MANAGED_ELEMENT_ID = TRILL.DEST_ME_ID and
DEST_SWITCH_PORT.VIRTUAL_SWITCH_ID = DEST_VIRTUAL_SWITCH.ID and
DEST_SWITCH_PORT.NAME = TRILL.DEST_PORT_NUMBER;
comment on view TRILL_INFO is 'This view is created to provide trill links as
defined in VCS and stored in TRILL table with the association of SWITCH_PORT';
TRILL_TRUNK_INFO
create or replace view TRILL_TRUNK_INFO as
select
TRILL_TRUNK_GROUP.ID,
TRILL_TRUNK_GROUP.ME_ID,
TRILL_TRUNK_GROUP.MASTER_PORT_NUMBER,
TRILL_TRUNK_MEMBER.PORT_NUMBER as MEMBER_PORT_NUMBER,
MEMBER_DEVICE.DEVICE_ID,
INTERFACE.INTERFACE_ID,
VCS_CLUSTER_MEMBER.CLUSTER_ME_ID,
CLUSTER_DEVICE.DEVICE_ID as CLUSTER_DEVICE_ID
from
TRILL_TRUNK_GROUP