cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
nickthorpe
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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