User Manual v12.3.0 Owner's manual

ManualsBrandsBrocade ManualsSoftwareNetwork Advisor IP

1891

1840 Brocade Network Advisor IP User Manual

53-1003153-01

Views

left join (select PROFILE_ID, array_agg(VLANID)::varchar as VLAN from

PORT_PROFILE_VLAN_MAP group by PROFILE_ID) PROFILE_VLAN_MAP on

PROFILE_VLAN_MAP.PROFILE_ID = PORT_PROFILE.ID

left join VM_NETWORK_SETTINGS on VM_NETWORK_SETTINGS.VM_STD_VSWITCH_PORT_GROUP_ID

= VM_VIRTUAL_ETHERNET_ADAPTER.VM_STD_VSWITCH_PORT_GROUP_ID

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_VIRTUAL_MACHINE.HOST_ID = VM_HOST.DEVICE_ENCLOSURE_ID and

VM_HOST.VM_DATACENTER_ID = VM_DATA_CENTER.ID

union

select VNIC_DV_PORT.VNIC_ID as VNIC_ID,

VNIC_DV_PORT.MAC_ADDRESS,VNIC_DV_PORT.VM_IP_ADDRESS,VNIC_DV_PORT.DISPLAY_LABEL,

VNIC_DV_PORT.PORT_GROUP_NAME, VNIC_DV_PORT.VM_ID,

VNIC_DV_PORT.VIRTUAL_MACHINE_NAME, VNIC_DV_PORT.HOST_ID, VNIC_DV_PORT.HOST_NAME,

VNIC_DV_PORT.HOST_NAME, VNIC_DV_PORT.DATA_CENTER_ID,

VNIC_DV_PORT.VM_STD_VSWITCH_PORT_GROUP_ID as STD_PORT_GROUP_ID,

VNIC_DV_PORT.DV_PORT_ID, PNIC_DV_PORT.PORT_GROUP_NAME as UPLINK_PORT_GROUP_NAME,

VNIC_DV_PORT.SWITCH_NAME as VM_SWITCH_NAME, PNIC_DV_PORT.PNIC_MAC,

VM_HOST_END_DEV_CONNECTIVITY.INTERFACE_ID, INTERFACE.NAME as INTERFACE_NAME,

INTERFACE.DEVICE_ID as SWITCH_ID, DEVICE.IP_ADDRESS as SWITCH_IP, DEVICE.SYS_NAME

as SWITCH_NAME, DEVICE.OPER_STATUS as SWITCH_STATUS, CLUSTER_DEVICE.VCS_LICENSED,

PORT_PROFILE.NAME as PORT_PROFILE_NAME,

PROFILE_DOMAINS.DOMAIN_NAMES as PORT_PROFILE_DOMAIN_NAMES, PROFILE_VLAN_MAP.VLAN

as PORT_PROFILE_VLAN, VM_NETWORK_SETTINGS.VLAN_IDS as PORT_GROUP_VLAN

from

(select VNIC.ID as VNIC_ID, VNIC.MAC_ADDRESS,VNIC.IP_ADDRESS as VM_IP_ADDRESS,

VNIC.DISPLAY_LABEL, VNIC.PORT_GROUP_NAME, VNIC.VM_STD_VSWITCH_PORT_GROUP_ID,

VM_VIRTUAL_MACHINE.ID as VM_ID,

VM_VIRTUAL_MACHINE.NAME as VIRTUAL_MACHINE_NAME, VM_VIRTUAL_MACHINE.HOST_ID as

HOST_ID, VM_VCENTER_MEMBER.HOST_NAME, VM_HOST.CLUSTER_NAME, VM_DATA_CENTER.ID as

DATA_CENTER_ID,

DVPORT.ID as DV_PORT_ID, DVPORT.VM_DV_SWITCH_ID, VM_DV_SWITCH.NAME as

SWITCH_NAME

from VM_VIRTUAL_MACHINE, VM_VCENTER_MEMBER, VM_HOST, VM_DATA_CENTER,

VM_VIRTUAL_ETHERNET_ADAPTER VNIC, VM_DV_PORT DVPORT, VM_DV_SWITCH

where VNIC.VM_DV_PORT_ID = DVPORT.ID and VNIC.VIRTUAL_MACHINE_ID =

VM_VIRTUAL_MACHINE.ID and

VM_VIRTUAL_MACHINE.HOST_ID = VM_VCENTER_MEMBER.VM_HOST_ID and

DVPORT.VM_DV_SWITCH_ID = VM_DV_SWITCH.ID and VM_VIRTUAL_MACHINE.HOST_ID =

VM_HOST.DEVICE_ENCLOSURE_ID AND

VM_HOST.VM_DATACENTER_ID = VM_DATA_CENTER.ID) as VNIC_DV_PORT

left join VM_DV_PORT on VM_DV_PORT.ID = VNIC_DV_PORT.DV_PORT_ID

left join VM_NETWORK_SETTINGS on VM_NETWORK_SETTINGS.VM_DV_PORT_GROUP_ID =

VM_DV_PORT.VM_DV_PORT_GROUP_ID,

(select DVPORT.VM_DV_SWITCH_ID, DVPORTGROUP.ID as DV_PORT_GROUP_ID,

DVPORTGROUP.NAME as PORT_GROUP_NAME, PNIC.ID as PNIC_ID, PNIC.MAC_ADDRESS as

PNIC_MAC

from VM_PHYSICAL_NIC PNIC, VM_DV_PORT DVPORT, VM_DV_PORT_GROUP DVPORTGROUP

where PNIC.VM_DV_PORT_ID = DVPORT.ID and DVPORT.VM_DV_PORT_GROUP_ID =

DVPORTGROUP.ID) as PNIC_DV_PORT

join VM_HOST_END_DEV_CONNECTIVITY on

VM_HOST_END_DEV_CONNECTIVITY.VM_PHYSICAL_NIC_ID = PNIC_DV_PORT.PNIC_ID

left join INTERFACE on INTERFACE.INTERFACE_ID =

VM_HOST_END_DEV_CONNECTIVITY.INTERFACE_ID

left join DEVICE on DEVICE.DEVICE_ID = INTERFACE.DEVICE_ID