Find which ESXi host a VM is on

Posted by robd on April 21, 2016
Encyrption

To identify the host on which the virtual machine runs, use one of these methods:

 

Query the vCenter Server database in MSSQL:

  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 :

    This query returns the virtual machine ID, virtual machine name, host ID, and host name.

SQL_VMWare

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Copy Protected by Chetan's WP-Copyprotect.