
1850
Brocade Network Advisor SAN User Manual
53-1003154-01
Views
H
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,
FC_PORT_STATS.TX,
FC_PORT_STATS.RX,
FC_PORT_STATS.TX_UTILIZATION,
FC_PORT_STATS.RX_UTILIZATION,
FC_PORT_STATS.SYNCLOSSES,
FC_PORT_STATS.SIGNALLOSSES,
FC_PORT_STATS.SEQUENCEERRORS,
FC_PORT_STATS.INVALIDTRANSMISSIONS,
FC_PORT_STATS.CRCERRORS,
FC_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,
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,
Summary of Contents for Network Advisor 12.3.0
Page 4: ...iv Brocade Network Advisor SAN User Manual 53 1003154 01...
Page 86: ...34 Brocade Network Advisor SAN User Manual 53 1003154 01 Uninstalling a patch 2...
Page 190: ...138 Brocade Network Advisor SAN User Manual 53 1003154 01 Fabric tracking 4...
Page 216: ...164 Brocade Network Advisor SAN User Manual 53 1003154 01 User profiles 5...
Page 612: ...560 Brocade Network Advisor SAN User Manual 53 1003154 01 Exporting Host port mapping 13...
Page 620: ...568 Brocade Network Advisor SAN User Manual 53 1003154 01 Exporting storage port mapping 14...
Page 720: ...668 Brocade Network Advisor SAN User Manual 53 1003154 01 Security configuration deployment 17...
Page 744: ...692 Brocade Network Advisor SAN User Manual 53 1003154 01 Configuring Virtual Fabrics 19...
Page 1068: ...1016 Brocade Network Advisor SAN User Manual 53 1003154 01 Removing thresholds 24...
Page 1098: ...1046 Brocade Network Advisor SAN User Manual 53 1003154 01 Swapping blades 25...
Page 1176: ...1124 Brocade Network Advisor SAN User Manual 53 1003154 01 SAN connection utilization 28...
Page 1378: ...1326 Brocade Network Advisor SAN User Manual 53 1003154 01 Event logs 32...
Page 1448: ...1396 Brocade Network Advisor SAN User Manual 53 1003154 01 Upload failure data capture 34...
Page 1490: ...1438 Brocade Network Advisor SAN User Manual 53 1003154 01 SAN shortcut menus A...
Page 1494: ...1442 Brocade Network Advisor SAN User Manual 53 1003154 01 Call Home Event Tables B...
Page 1524: ...1472 Brocade Network Advisor SAN User Manual 53 1003154 01 About Roles and Access Levels D...
Page 1552: ...1500 Brocade Network Advisor SAN User Manual 53 1003154 01 Regular Expressions F...
Page 1920: ...1868 Brocade Network Advisor SAN User Manual 53 1003154 01 Views H...