Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

ManualsBrandsHP ManualsStorageHP SN8000B 8-slot Power Pack+ SAN Backbone Director Switch

261

262

263

264

265

266

267

268

269

270

Table Of Contents

1544 Brocade Network Advisor SAN User Manual

53-1002948-01

Views

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

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;