Brocade Communications Systems IP250 user manual Switchport.Portid Switchport.Portnumber

I Views

SWITCH_PORT.PORT_ID,

SWITCH_PORT.PORT_NUMBER

from

VM_STORAGE, VM_HOST,

DEVICE_ENCLOSURE, VM_VIRTUAL_MACHINE, VM_PATH,

DEVICE_PORT,

SWITCH_PORT,

CORE_SWITCH, FC_PORT_STATS, VIRTUAL_SWITCH

where

VM_PATH.HBA_PORT::BPCHAR = DEVICE_PORT.WWN

and VM_PATH.VM_ID = VM_VIRTUAL_MACHINE.ID and VM_PATH.STORAGE_ID = VM_STORAGE.ID

and VM_STORAGE.HOST_ID = DEVICE_ENCLOSURE.ID

and DEVICE_ENCLOSURE.ID = VM_HOST.DEVICE_ENCLOSURE_ID

and DEVICE_ENCLOSURE.ID = VM_VIRTUAL_MACHINE.HOST_ID and DEVICE_PORT.SWITCH_PORT_WWN = SWITCH_PORT.WWN and SWITCH_PORT.ID = FC_PORT_STATS.PORT_ID

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

and FC_PORT_STATS.CREATION_TIME in (select MAX(CREATION_TIME) from FC_PORT_STATS group by PORT_ID)

union

select

DEVICE_PORT.SWITCH_PORT_WWN, DEVICE_PORT.DOMAIN_ID, DEVICE_ENCLOSURE.IP_ADDRESS as HYPERVISOR_HOST, VM_PATH.HBA_PORT as ADAPTER_PORT_WWN,

VM_VIRTUAL_MACHINE.HYPERVISOR_VM_ID,

VM_VIRTUAL_MACHINE.NAME as VM_NAME,

CORE_SWITCH.IP_ADDRESS,

CORE_SWITCH.NAME as CORE_NAME,

SWITCH_TE_PORT_STATS.TRANSMIT_OK,

SWITCH_TE_PORT_STATS.RECEIVE_OK,

SWITCH_TE_PORT_STATS.TRANSMIT_OK_PERCENT_UTIL, SWITCH_TE_PORT_STATS.RECEIVE_OK_PERCENT_UTIL, (-1) AS SYNCLOSSES,

(-1) AS SIGNALLOSSES,

(-1) AS SEQUENCEERRORS,

(-1) AS INVALIDTRANSMISSIONS,

(-1) AS CRCERRORS,

SWITCH_TE_PORT_STATS.CREATION_TIME,

VIRTUAL_SWITCH.NAME as VIRTUAL_NAME, SWITCH_PORT.STATUS as SWITCH_PORT_STATUS, SWITCH_PORT.PORT_ID,

SWITCH_PORT.PORT_NUMBER

from

VM_STORAGE, VM_HOST,

DEVICE_ENCLOSURE, VM_VIRTUAL_MACHINE, VM_PATH,

DEVICE_PORT,

SWITCH_PORT,

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