Isl_trunk_group_member_info – Brocade Network Advisor SAN + IP User Manual v12.3.0 User Manual

Page 2618

2546

Brocade Network Advisor SAN + IP User Manual

53-1003155-01

Views

DEST_SWITCH_PORT.IDENTIFIER as DEST_SWITCH_PORT_IDENTIFIER,

DEST_SWITCH_PORT.KIND as DEST_SWITCH_PORT_KIND,

DEST_SWITCH_PORT.PHYSICAL_PORT as DEST_PHYSICAL_PORT,

DEST_SWITCH_PORT.TRUNKED as DEST_SWITCH_PORT_TRUNKED

from

ISL,

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 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.MISSING,

ISL_TRUNK_MEMBER.TRUSTED,

ISL_TRUNK_MEMBER.MISSING_TIME,

ISL_TRUNK_MEMBER.PORT_NUMBER,

SWITCH_PORT.WWN,

SWITCH_PORT.TYPE,

SWITCH_PORT.STATUS,

SWITCH_PORT.SPEED,

SWITCH_PORT.ID as SWITCH_PORT_ID,

SWITCH_PORT.SPEED_TYPE

from

ISL_TRUNK_GROUP,

ISL_TRUNK_MEMBER,