VMware Server Report

[nickthorpe]

Hi,

Fantastic product !!

I just need some help with writing some reports !!

I need to be able to produce a report that lists all ESX Host Servers with the relevant Virtual Machines associated to each ESX Host.

Any help would be greatly appreciated.

[Hemoco · Accepted solution]

Sample report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblVmwareInfo.Version,
tblVmwareGuest.Name As Guest,
tblVmwareGuest.Memory,
tblVmwareGuest.IsRunning As State,
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
Order By tblAssets.AssetName,
Guest