→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
BS
Engaged Sweeper
I saw the VMWARE: Virtual Guest Machines report, and was curious on how I could get the ip address of EACH guest in the report. The ip address in the report is the address of the ESX host.

Any idea would be appreciated.

1 REPLY 1
saumil18
Engaged Sweeper
BS wrote:
I saw the VMWARE: Virtual Guest Machines report, and was curious on how I could get the ip address of EACH guest in the report. The ip address in the report is the address of the ESX host.

Any idea would be appreciated.



Try this:


Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblVmwareInfo.Version,
tblVmwareGuest.Name As Guest,
tblAssets1.IPAddress As GuestIPAddress,
tblOperatingsystem.Caption As [os guest],
tblVmwareGuest.Memory,
tblVmwareGuest.IsRunning As State,
Case When tblVmwareGuest.IsRunning Like '%Poweredoff%' Then 'red'
End As foregroundcolor,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblVmwareGuest.lastchanged
From tblAssets
Inner Join tblVmwareGuest On tblAssets.AssetID = tblVmwareGuest.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblVmwareInfo On tblAssets.AssetID = tblVmwareInfo.AssetID
Left Join tblVmwareGuestNetwork On tblVmwareGuest.GuestID =
tblVmwareGuestNetwork.GuestID
Left Join tblAssets tblAssets1
On tblAssets1.Mac = tblVmwareGuestNetwork.MacAddress
Left Join tblOperatingsystem
On tblAssets1.AssetID = tblOperatingsystem.AssetID
Order By tblAssets.AssetName,
Guest