Brocade Communications Systems IP250 Virtualportwwndetailsinfo, Virtualportwwndetails.Switchid

I Views

VIRTUAL_FCOE_PORT.VIRTUAL_SWITCH_ID, VIRTUAL_FCOE_PORT.PORT_WWN, VIRTUAL_FCOE_PORT.PORT_SPEED, VIRTUAL_FCOE_PORT.PORT_TYPE, VIRTUAL_FCOE_PORT.ENABLED, VIRTUAL_FCOE_PORT.STATUS, VIRTUAL_FCOE_PORT.TRUNK_INDEX, VIRTUAL_FCOE_PORT.PORT_NUMBER, VIRTUAL_FCOE_PORT.NAME, VIRTUAL_FCOE_PORT.SLOT_NUMBER, VIRTUAL_FCOE_PORT.VLAN_ID,

VIRTUAL_FCOE_PORT.DEVICE_COUNT, VIRTUAL_FCOE_PORT.PEER_MAC, VIRTUAL_SWITCH.WWN as VIRTUAL_SWITCH_WWN, VIRTUAL_SWITCH.ROLE as SWITCH_ROLE,

VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID as VIRTUAL_FABRIC_ID, VIRTUAL_SWITCH.DOMAIN_ID as DOMAIN_ID, VIRTUAL_SWITCH.INTEROP_MODE as INTEROP_MODE,

VIRTUAL_SWITCH.MANAGEMENT_STATE, VIRTUAL_SWITCH.MONITORED, CORE_SWITCH.TYPE as SWITCH_TYPE,

CORE_SWITCH.FIRMWARE_VERSION as FIRMWARE_VERSION, CORE_SWITCH.IP_ADDRESS as IP_ADDRESS, CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN, CORE_SWITCH.MODEL as SWITCH_MODEL, CORE_SWITCH_DETAILS.MODEL_NUMBER as SWITCH_MODEL_NUMBER

from

VIRTUAL_FCOE_PORT, CORE_SWITCH, VIRTUAL_SWITCH, CORE_SWITCH_DETAILS where

VIRTUAL_FCOE_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID and VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID and

CORE_SWITCH_DETAILS.CORE_SWITCH_ID = CORE_SWITCH.ID;

VIRTUAL_PORT_WWN_DETAILS_INFO

create or replace view VIRTUAL_PORT_WWN_DETAILS_INFO as select distinct

VIRTUAL_PORT_WWN_DETAILS.SWITCH_ID,

VIRTUAL_PORT_WWN_DETAILS.SWITCH_PORT_NUMBER, VIRTUAL_PORT_WWN_DETAILS.SLOT_NUMBER,

coalesce(CS1.IP_ADDRESS, CS2.IP_ADDRESS, UDDD.IP_ADDRESS) as IP_ADDRESS, coalesce(VS1.NAME, VS2.NAME, UDDD.NAME) as SWITCH_NAME, coalesce(VS1.WWN, VS2.WWN) as SWITCH_WWN,

VIRTUAL_PORT_WWN_DETAILS.AG_NODE_WWN, VIRTUAL_PORT_WWN_DETAILS.AG_PORT_NUMBER, VIRTUAL_PORT_WWN_DETAILS.STATUS, VIRTUAL_PORT_WWN_DETAILS.TYPE, VIRTUAL_PORT_WWN_DETAILS.USER_VPWWN, VIRTUAL_PORT_WWN_DETAILS.AUTO_VPWWN, VIRTUAL_PORT_WWN_DETAILS.DEVICE_PORT_WWN, coalesce(SP1.ID, SP2.ID) as SWITCH_PORT_ID, coalesce(SP1.WWN, SP2.WWN) as PORT_WWN, coalesce(SP1.TYPE, SP2.TYPE) AS PORT_TYPE, coalesce(SP1.NAME, SP2.NAME) as PORT_NAME

from

VIRTUAL_PORT_WWN_DETAILS

left outer join VIRTUAL_SWITCH VS1

on (VIRTUAL_PORT_WWN_DETAILS.AG_PORT_NUMBER = -1 and VIRTUAL_PORT_WWN_DETAILS.SWITCH_ID = VS1.ID)

1660	Brocade Network Advisor IP User Manual
	53-1003056-01