Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2349)

2312 Brocade Network Advisor SAN + IP User Manual
53-1002949-01
Views
I
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,
CORE_SWITCH,
SWITCH_TE_PORT_STATS,
VIRTUAL_SWITCH,
DEVICE_PORT_MAC_ADDRESS_MAP,
DEVICE_PORT_GIGE_PORT_LINK,
GIGE_PORT
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.ID = DEVICE_PORT_MAC_ADDRESS_MAP.DEVICE_PORT_ID
and DEVICE_PORT_MAC_ADDRESS_MAP.MAC_ADDRESS = GIGE_PORT.REMOTE_MAC_ADDRESS
and GIGE_PORT.SWITCH_PORT_ID = SWITCH_TE_PORT_STATS.PORT_ID
and GIGE_PORT.SWITCH_PORT_ID = SWITCH_PORT.ID
and SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID
and VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID
and SWITCH_TE_PORT_STATS.CREATION_TIME in (select max(CREATION_TIME) from
SWITCH_TE_PORT_STATS group by PORT_ID);