Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by
  • When: 2 Mar 2010 8:09 AM
  • Last revision by (aMicrosof)
  • When: 16 Sep 2013 4:22 PM
  • Revisions: 16
  • Comments: 14
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  Hyper-V: How to Find the Host of a VM

Hyper-V: How to Find the Host of a VM

Hyper-V: How to Find the Host of a VM

There are several ways you can determine the virtualization host (server with the Hyper-V role enabled), also called the physical host, that a VM is running on.

If the host OS is Windows Server 2008 R2, and the virtual machines on it are using the R2 integrations services, then you can query the following:

$[HKLM\SOFTWARE\Microsoft\Virtual Machine\Guest\Parameters]
"HostName"=
"PhysicalHostName"="
"PhysicalHostNameFullyQualified"=
"VirtualMachineName"=

Using SCVMM:

Get-VMMServer cluster.domain.com | Get-VM Server1 | Select-Object vmhost

Replace cluster.domain.com to the FQDN of your VMM cluster and Server1 to the server you're looking for.

Using PowerShell:

This script pulls the host name from the VM's registry.

Function Get-VMHost
{
    (get-item "HKLM:\SOFTWARE\Microsoft\Virtual Machine\Guest\Parameters").GetValue("HostName")
}

Using WMI and PowerShell

function Get-VMOSDetail
{
    Param(
        [Parameter()]
        $ComputerName = $Env:ComputerName,
         
        [Parameter()]
        $VMName
         
    )
     
    # Creating HASH Table for object creation
    $MyObj = @{}
     
    # Getting VM Object
    $Vm = Get-WmiObject -Namespace root\virtualization -Query "Select * From Msvm_ComputerSystem Where ElementName='$VMName'" -ComputerName $ComputerName
     
    # Getting VM Details
    $Kvp = Get-WmiObject -Namespace root\virtualization -Query "Associators of {$Vm} Where AssocClass=Msvm_SystemDevice ResultClass=Msvm_KvpExchangeComponent" -ComputerName $ComputerName
     
    # Converting XML to Object
    foreach($CimXml in $Kvp.GuestIntrinsicExchangeItems)
    {
 
        $XML = [XML]$CimXml
 
        if($XML)
        {
            foreach ($CimProperty in $XML.SelectNodes("/INSTANCE/PROPERTY"))
            {
                switch -exact ($CimProperty.Name)
                {
                    "Data"      { $Value = $CimProperty.VALUE }
                    "Name"      { $Name  = $CimProperty.VALUE }
                }
            }
            $MyObj.add($Name,$Value)
        }
    }
     
    # Outputting Object
    New-Object -TypeName PSCustomObject -Property $MyObj
     
}


Using System Center Configuration Manager:

This T-SQL query can be used to generate a report giving the number of hosts per guest:

SELECT [PhysicalHostNameFullyQualifi0] AS [Host FQDN], COUNT(PhysicalHostNameFullyQualifi0) AS [Count of Guests]
  FROM [v_GS_VIRTUAL_MACHINE]
  GROUP BY [PhysicalHostNameFullyQualifi0]
This T-SQL query can used to generate a report matching hosts to guests 


SELECT sys.Netbios_Name0, vm.PhysicalHostName0, vm.ResourceID
FROM dbo.v_GS_VIRTUAL_MACHINE AS vm
JOIN v_R_System AS sys ON vm.ResourceID = sys.ResourceID

Using MMC:

Resources:




, , , , , , , , , [Edit tags]
Leave a Comment
  • Please add 1 and 5 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 28 Jan 2012 10:30 AM

    BSonPosh edited Revision 9. Comment: Adding My code to get VMOSDetail

  • 11 Oct 2011 3:57 AM

    John Grenfell edited Revision 8. Comment: Sample code to get the host of a vm on a vmm cluster - my first wiki post - please be gentle!

  • 3 Mar 2010 10:10 AM

    Saud AlMishari MSFT edited Revision 4. Comment: Updated article to clarify that SQL query is for ConfigMgr only.

  • 3 Mar 2010 8:50 AM

    Tony Soper_MSFT edited Revision 1. Comment: added get count of guests by host script

  • 2 Mar 2010 8:09 AM

    Tony Soper_MSFT edited Original. Comment: Added PSH script and Resources

Page 1 of 1 (5 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 2 Mar 2010 8:09 AM

    Tony Soper_MSFT edited Original. Comment: Added PSH script and Resources

  • Posted by
    on 3 Mar 2010 8:50 AM

    Tony Soper_MSFT edited Revision 1. Comment: added get count of guests by host script

  • Posted by
    on 3 Mar 2010 10:10 AM

    Saud AlMishari MSFT edited Revision 4. Comment: Updated article to clarify that SQL query is for ConfigMgr only.

  • Posted by
    on 19 Jul 2011 3:14 AM

    hi, this is good info. however, is there any way for me to check the "history" host owner of one particular virtual machine?  

  • Posted by
    on 19 Jul 2011 9:21 AM

    Raymond: Please clarify - are you looking for the "owner" of a virtual machine, regardless of the host it is currently on, or may have been on in the past?

    Or,

    Are you looking for a list of all the hosts a particular VM has been on?

  • Posted by
    on 19 Jul 2011 11:08 AM

    AFAIK there is no way to track "host history" of a VM *on* or "from" the VM. If you have the required credentials and access to the *host* log files, you should be able to parse and track who/what regarding any VM on the host.

  • Posted by
    on 19 Jul 2011 7:38 PM

    hi tonyso, thanks for ur feedbac.   i m looking for the history (past) host where my desire VM located....  looks there is no other way besides checking from cluster.log ...

    Hi tonysoper, mind to share the step?

  • Posted by
    on 20 Jul 2011 11:18 AM

    Raymond, If I understand correctly what you are trying to do, there is no way to do that in Hyper-V. I am not positive, but I don't think there is a way in SCVMM either. You should check with the SCVMM community just to be sure, try social.technet.microsoft.com/.../virtualmachinemanager

  • Posted by
    on 26 Sep 2011 4:06 PM

    The PowerShell above can be replaced with a one-liner:

    (get-item "HKLM:\SOFTWARE\Microsoft\Virtual Machine\Guest\Parameters").GetValue("HostName")

  • Posted by
    on 11 Oct 2011 3:57 AM

    John Grenfell edited Revision 8. Comment: Sample code to get the host of a vm on a vmm cluster - my first wiki post - please be gentle!

  • Posted by
    on 28 Jan 2012 10:30 AM

    BSonPosh edited Revision 9. Comment: Adding My code to get VMOSDetail

  • Posted by
    on 30 Aug 2012 1:47 PM

    It's really great!

  • Posted by
    on 17 Feb 2013 7:01 AM

    thanks for sharing, helpful post

  • Posted by
    on 17 Feb 2013 7:08 AM

    nice article

Page 1 of 1 (14 items)