Brocade Communications Systems Network Advisor 12.0.0, Руководство пользователя

Страница: 1436 / 1505

1388 Brocade Network Advisor SAN User Manual
53-1002696-01
Views
H
DEVICE VCS_DEVICE,
VCS_CLUSTER_MEMBER SOURCE_CLUSTER_MEMBER,
VCS_CLUSTER_MEMBER DEST_CLUSTER_MEMBER,
DEVICE SOURCE_DEVICE,
SWITCH_PORT SOURCE_SWITCH_PORT,
FABRIC_MEMBER SOURCE_FABRIC_MEMBER,
VIRTUAL_SWITCH SOURCE_VIRTUAL_SWITCH,
DEVICE DEST_DEVICE,
SWITCH_PORT DEST_SWITCH_PORT,
FABRIC_MEMBER DEST_FABRIC_MEMBER,
VIRTUAL_SWITCH DEST_VIRTUAL_SWITCH,
FABRIC
where
SOURCE_FABRIC_MEMBER.FABRIC_ID = ISL.FABRIC_ID and
SOURCE_VIRTUAL_SWITCH.ID = SOURCE_FABRIC_MEMBER.VIRTUAL_SWITCH_ID and
SOURCE_VIRTUAL_SWITCH.DOMAIN_ID = ISL.SOURCE_DOMAIN_ID and
SOURCE_SWITCH_PORT.VIRTUAL_SWITCH_ID = SOURCE_VIRTUAL_SWITCH.ID and
SOURCE_SWITCH_PORT.USER_PORT_NUMBER = ISL.SOURCE_PORT_NUMBER and
DEST_FABRIC_MEMBER.FABRIC_ID = ISL.FABRIC_ID and
DEST_VIRTUAL_SWITCH.ID = DEST_FABRIC_MEMBER.VIRTUAL_SWITCH_ID and
DEST_VIRTUAL_SWITCH.DOMAIN_ID = ISL.DEST_DOMAIN_ID and
DEST_SWITCH_PORT.VIRTUAL_SWITCH_ID = DEST_VIRTUAL_SWITCH.ID and
DEST_SWITCH_PORT.USER_PORT_NUMBER = ISL.DEST_PORT_NUMBER and
FABRIC.ID = ISL.FABRIC_ID and
SOURCE_VIRTUAL_SWITCH.MANAGED_ELEMENT_ID = SOURCE_DEVICE.MANAGED_ELEMENT_ID
and
DEST_VIRTUAL_SWITCH.MANAGED_ELEMENT_ID = DEST_DEVICE.MANAGED_ELEMENT_ID and
SOURCE_CLUSTER_MEMBER.MEMBER_ME_ID = SOURCE_DEVICE.MANAGED_ELEMENT_ID and
DEST_CLUSTER_MEMBER.MEMBER_ME_ID = DEST_DEVICE.MANAGED_ELEMENT_ID and
VCS_DEVICE.MANAGED_ELEMENT_ID = SOURCE_CLUSTER_MEMBER.CLUSTER_ME_ID;
ISL_TRUNK_GROUP_MEMBER_INFO
create or replace view ISL_TRUNK_GROUP_MEMBER_INFO as
select
ISL_TRUNK_GROUP.ID,
ISL_TRUNK_GROUP.VIRTUAL_SWITCH_ID,
ISL_TRUNK_GROUP.MASTER_USER_PORT,
ISL_TRUNK_MEMBER.PORT_NUMBER,
SWITCH_PORT.WWN,
SWITCH_PORT.TYPE,
SWITCH_PORT.STATUS,
SWITCH_PORT.SPEED,
SWITCH_PORT.ID as SWITCH_PORT_ID
from
ISL_TRUNK_GROUP,
ISL_TRUNK_MEMBER,
SWITCH_PORT
where
ISL_TRUNK_GROUP.id = ISL_TRUNK_MEMBER.GROUP_ID
and ISL_TRUNK_GROUP.VIRTUAL_SWITCH_ID = SWITCH_PORT.VIRTUAL_SWITCH_ID
and ISL_TRUNK_MEMBER.PORT_NUMBER= SWITCH_PORT.USER_PORT_NUMBER;
ISL_TRUNK_INFO
create or replace view ISL_TRUNK_INFO as
select