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

1566 Brocade Network Advisor SAN User Manual
53-1002948-01
Views
H
and VIRTUAL_PORT_WWN_DETAILS.SLOT_NUMBER = SP1.SLOT_NUMBER
and VIRTUAL_PORT_WWN_DETAILS.SWITCH_PORT_NUMBER = SP1.PORT_NUMBER
and SP1.TYPE NOT IN ('GigE-Port','TE-Port'))
left outer join SWITCH_PORT SP2
on (SP2.VIRTUAL_SWITCH_ID=VS2.ID
and VIRTUAL_PORT_WWN_DETAILS.AG_PORT_NUMBER = SP2.PORT_NUMBER
and SP2.TYPE NOT IN ('GigE-Port','TE-Port'))
left outer join USER_DEFINED_DEVICE_DETAIL UDDD
on VIRTUAL_PORT_WWN_DETAILS.AG_NODE_WWN = UDDD.WWN;
VM_ADDRESS_INFO
create or replace view VM_ADDRESS_INFO AS
select
DECODE(VM_VIRTUAL_ETHERNET_ADAPTER.MAC_ADDRESS::TEXT, 'HEX'::TEXT) AS
MAC_ADDRESS,
VM_VIRTUAL_MACHINE.NAME AS VM_NAME,
DECODE(VM_VIRTUAL_MACHINE.IP_ADDRESS::TEXT, 'HEX'::TEXT) AS VM_ADDRESS,
VM_VCENTER_MEMBER.HOST_NAME AS VM_HOST_NAME,
DECODE(VM_VIRTUAL_MACHINE.IP_ADDRESS::TEXT, 'HEX'::TEXT) AS VM_HOST_ADDRESS,
VM_VIRTUAL_ETHERNET_ADAPTER.VIRTUAL_MACHINE_ID AS VM_ID,
VM_VIRTUAL_MACHINE.HOST_ID AS VM_HOST_ID
FROM
VM_VIRTUAL_MACHINE,
VM_VIRTUAL_ETHERNET_ADAPTER,
VM_VCENTER_MEMBER
WHERE
VM_VIRTUAL_MACHINE.ID = VM_VIRTUAL_ETHERNET_ADAPTER.VIRTUAL_MACHINE_ID
AND VM_VIRTUAL_MACHINE.HOST_ID = VM_VCENTER_MEMBER.VM_HOST_ID;
VM_CONNECTIVITY_INFO
This view combines fabric and VM information to derive end to end connectivity information for the
VM.
create or replace view VM_CONNECTIVITY_INFO as
select
VM_VCENTER.HOST AS VCENTER_HOST,
DEVICE_PORT.SWITCH_PORT_WWN,
DEVICE_PORT.DOMAIN_ID,
device_port.id as device_port_id,
DEVICE_PORT.NUMBER,
CORE_SWITCH.IP_ADDRESS,
CORE_SWITCH.NAME AS CORE_NAME,
VM_VCENTER.ID AS VCENTER_ID,
DEVICE_ENCLOSURE.ID AS HOST_DB_ID,
DEVICE_ENCLOSURE.IP_ADDRESS AS HYPERVISOR_HOST,
VM_VIRTUAL_MACHINE.ID as VM_ID,
VM_VIRTUAL_MACHINE.IP_ADDRESS AS VM_IP_ADDRESS,
VM_VIRTUAL_MACHINE.HOSTNAME AS VM_HOST_NAME,
VM_VIRTUAL_MACHINE.UUID AS VM_UUID,
VM_VIRTUAL_MACHINE.NAME AS VM_NAME,
VM_PATH.NAME AS PATH_NAME,
VM_PATH.HBA_PORT AS ADAPTER_PORT_WWN,
VM_PATH.TARGET_PORT AS TARGET_PORT_WWN,
VM_STORAGE.NAME AS LUN_CAN_NAME,