Brocade Network Advisor SAN User Manual v12.1.0 - Manual (Page 1656)

Brocade Network Advisor SAN User Manual 1609
53-1002948-01
Views
H
VM_HOST_VIRTUAL_NIC,
VM_VCENTER_MEMBER,
VM_VCENTER
where
VM_HOST_VIRTUAL_NIC.VM_HOST_ID = VM_VCENTER_MEMBER.VM_HOST_ID AND
VM_VCENTER_MEMBER.VM_VCENTER_ID = VM_VCENTER.ID
union all
select
VM_PHYSICAL_NIC.MAC_ADDRESS,
VM_PHYSICAL_NIC.DEVICE_NAME,
NULL::UNKNOWN AS PORT_GROUP_NAME,
NULL::UNKNOWN AS VIRTUAL_MACHINE_NAME,
VM_VCENTER_MEMBER.HOST_NAME,
VM_VCENTER.NAME AS VCENTER_NAME
from
VM_PHYSICAL_NIC,
VM_VCENTER_MEMBER,
VM_VCENTER
where
VM_PHYSICAL_NIC.VM_HOST_ID = VM_VCENTER_MEMBER.VM_HOST_ID AND
VM_VCENTER_MEMBER.VM_VCENTER_ID = VM_VCENTER.ID;
VM_VIRTUAL_ETHERNET_ADAPTER_INFO
create or replace view VM_VIRTUAL_ETHERNET_ADAPTER_INFO as
select
VM_VIRTUAL_ETHERNET_ADAPTER.ID,
VM_VIRTUAL_ETHERNET_ADAPTER.MAC_ADDRESS,
VM_VIRTUAL_ETHERNET_ADAPTER.DISPLAY_LABEL,
VM_VIRTUAL_ETHERNET_ADAPTER.PORT_GROUP_NAME,
VM_VIRTUAL_MACHINE.NAME as VIRTUAL_MACHINE_NAME,
VM_VCENTER_MEMBER.HOST_NAME,
VM_VCENTER.NAME as VCENTER_NAME
From
VM_VIRTUAL_ETHERNET_ADAPTER,
VM_VIRTUAL_MACHINE,
VM_VCENTER_MEMBER,
VM_VCENTER
Where
VM_VIRTUAL_ETHERNET_ADAPTER.VIRTUAL_MACHINE_ID = VM_VIRTUAL_MACHINE.ID
And VM_VIRTUAL_MACHINE.HOST_ID = VM_VCENTER_MEMBER.VM_HOST_ID
And VM_VCENTER_MEMBER.VM_VCENTER_ID = VM_VCENTER.ID;
ZONE_DB_INFO
create or replace view ZONE_DB_INFO as
select
ZONE_DB.ID,
ZONE_DB.FABRIC_ID,
ZONE_DB.OFFLINE,
ZONE_DB.NAME,
ZONE_DB.CREATED,
ZONE_DB.CREATED_BY,
ZONE_DB.LAST_MODIFIED,
ZONE_DB.LAST_MODIFIED_BY,