Method 1

1. Log in to to the Microsoft SQL 2005/2008 Server as an administrator.
2. Open SQL Management Studio.
3. Right-click the database that vCenter Server is using.
4. Open a new query window and ensure that the vCenter Server database is selected.
5. Run this SQL statement :
   
   SELECT vpxv_vms.vmid, vpxv_vms.NAME, vpxv_vms.hostid, vpxv_hosts.NAME
   FROM vpxv_vms
   JOIN vpxv_hosts on VPXV_VMS.HOSTID = VPXV_HOSTS.HOSTID
   WHERE (
   (vpxv_hosts.hostid = vpxv_vms.hostid)
   AND (vpxv_vms.NAME = 'virtual_machine_name')
   )
   
   This query returns the virtual machine ID, virtual machine name, host ID, and host name.

Method 2

1. Open an SSH session to an ESX/ESXi host that has access to the shared storage (datastores) for the environment in which the virtual machine resides. For more information, see Connecting to an ESX host using a SSH client (1019852) or Using Tech Support Mode in ESXi 4.1 and ESXi 5.x (1017910).
2. Find the working directory for the virtual machine using one of these commands:
   • grep -i <virtual_machine_name> /vmfs/volumes/*/*/vmware-*.log
   • find /vmfs/volumes/ -name *.vmx | less
      
3. After locating the working directory of the virtual machine, check the latest vmware.log file and do the following steps on each Esxi host:

•  Go to the working directory of the Virtual machine.
• grep -i hostname vmware.log to determine the host on which the virtual machine is running

 Note: The host where the VM is running lock the vmware.log file and VM_name.vmx file, trying to access these files from another Esxi host will return error with device busy that's The previous steps should be run one each host.