Isltrunkgroupmemberinfo | Brocade Communications Systems IP250

I Views

SOURCE_DEVICE.DEVICE_ID as SOURCE_DEVICE_ID,

SOURCE_DEVICE.SYS_NAME as SOURCE_DEVICE_NAME,

SOURCE_SWITCH_PORT.ID as SOURCE_SWITCH_PORT_ID,

SOURCE_SWITCH_PORT.NAME as SOURCE_SWITCH_PORT_NAME,

SOURCE_SWITCH_PORT.IDENTIFIER as SOURCE_SWITCH_PORT_IDENTIFIER,

SOURCE_SWITCH_PORT.TYPE as PORT_TYPE,

SOURCE_SWITCH_PORT.KIND as SOURCE_SWITCH_PORT_KIND,

SOURCE_SWITCH_PORT.PHYSICAL_PORT as SOURCE_PHYSICAL_PORT,

SOURCE_SWITCH_PORT.TRUNKED as SOURCE_SWITCH_PORT_TRUNKED,

ISL.DEST_DOMAIN_ID,

ISL.DEST_PORT_NUMBER,

DEST_DEVICE.DEVICE_ID as DEST_DEVICE_ID,

DEST_DEVICE.MANAGED_ELEMENT_ID AS DEST_ME_ID,

DEST_DEVICE.SYS_NAME as DEST_DEVICE_NAME,

DEST_SWITCH_PORT.ID as DEST_SWITCH_PORT_ID,

DEST_SWITCH_PORT.NAME as DEST_SWITCH_PORT_NAME,

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;