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
