Virtual Machine report

[kaddynet]

Hi,

I'd like to have the following repport :

Guest Computer Name | Guest IP address | Host Computer Name | Host IP address

For now Ihave

Guest Name | Host Computer Name | Host IP address

In this case the Guest Name is not the computer

I don't know with with table I have to cross tblAssets to guest informations about the guest. I tried with tblHyperVGuest but in table I have only the virtual machine name (As written on my Hyper Config and with is not the computer name and I have no VM-IP ADDRESSES

Can someone provide me help

Thank you for your time

Christian K.

[rader]

kaddynet wrote:
Hi,

I'd like to have the following repport :

Guest Computer Name | Guest IP address | Host Computer Name | Host IP address

Try this on your Hyper-V servers. Works on my systems.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName As [Guest Computer Name],
  tblAssets.IPAddress As [Guest IP Address],
  tHost.AssetName As [Host Computer Name],
  tHost.IPAddress As [Host IP Address]
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join TblHyperVGuestNetwork On
    tblAssets.Mac = TblHyperVGuestNetwork.MacAddress
  Inner Join tblHyperVGuest On tblHyperVGuest.hypervguestID =
    TblHyperVGuestNetwork.HyperVGuestID
  Left Join tblAssets tHost On tHost.AssetID = tblHyperVGuest.AssetID
Where tblAssetCustom.State = 1
Order By [Host Computer Name]

[Esben_D]

I've posted a report which should show that info here: https://www.lansweeper.com/forum/yaf_postsm56938_Virtual-machines-and-their-host.aspx