Virtual machine with multiple networks display duplicate IP address in VCSA 6.7 vSphere client

Products

• VMware vSphere ESXi

Issue/Introduction

1.  In vSphere client, click virtual machine and in summary tab, if the virtual machine has multiple networks, duplicate IP address is displayed. 
2. If using ESXi web client to see the IP address, different IP addresses are displayed. 

Environment

VMware vSphere ESXi 6.7

Cause

This is a known issue that is being caused due to the presence of multiple networks.

To validate the presence of duplicate IP addresses :

1. Connect to the VCSA vpostgres database. 
2. Use the following SQL statement:
    
   1.   Query the id from vpx_entity for the virtual machine
          select id from vpx_entity where name like %virtual machine%;
   2. Query from table vpx_nic
          select * from vpx_nic where entity_id = <id> ----> this id is query by vpx_entity table. 
      
          You will see duplicate device_id and duplicate ip in ip_config column. 

Resolution

1. Upgrade vCenter Server to version 6.7 U3b
2. After upgrade, disconnect ESXi host from vCenter Server and reconnect it.