Brocade Communications Systems Network Advisor 12.3.0, User Manual

Page: 1891 / 1940

Brocade Network Advisor SAN User Manual 1839
53-1003154-01
Views
H
SOURCE_DEVICE.DEVICE_ID AS SOURCE_DEVICE_ID,
TRILL.DEST_DOMAIN_ID,
TRILL.DEST_PORT_NUMBER,
TRILL.DEST_PORT_NAME as DEST_SWITCH_PORT_NAME,
TRILL.DEST_ME_ID,
DEST_DEVICE.DEVICE_ID AS DEST_DEVICE_ID
from
TRILL,
device VCS_DEVICE,
device SOURCE_DEVICE,
VIRTUAL_SWITCH SOURCE_VIRTUAL_SWITCH,
device DEST_DEVICE,
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
DEST_VIRTUAL_SWITCH.MANAGED_ELEMENT_ID = TRILL.DEST_ME_ID;
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
inner join
TRILL_TRUNK_MEMBER on
TRILL_TRUNK_MEMBER.GROUP_ID = TRILL_TRUNK_GROUP.ID
inner join
DEVICE as MEMBER_DEVICE on
MEMBER_DEVICE.MANAGED_ELEMENT_ID = TRILL_TRUNK_GROUP.ME_ID
left outer join
INTERFACE on
INTERFACE.DEVICE_ID = MEMBER_DEVICE.DEVICE_ID and
INTERFACE.IDENTIFIER = TRILL_TRUNK_MEMBER.PORT_NUMBER
left outer join
VCS_CLUSTER_MEMBER on
VCS_CLUSTER_MEMBER.MEMBER_ME_ID = TRILL_TRUNK_GROUP.ME_ID
left outer join
DEVICE as CLUSTER_DEVICE on
CLUSTER_DEVICE.MANAGED_ELEMENT_ID = VCS_CLUSTER_MEMBER.CLUSTER_ME_ID;
USER_ROLE_RESOURCE_INFO
create or replace view USER_ROLE_RESOURCE_INFO as
select
RESOURCE_GROUP.ID RESOURCE_GROUP_ID,
RESOURCE_GROUP.NAME RESOURCE_GROUP_NAME,