VMWare Report

[Srikanth08]

Hi,

The built in Hyper V report is working fine. but the built in VMware report is not working.

Please help

[Daniel_B · Accepted solution]

Likely you also can't see information about guest machines on the asset page of the host. Lansweeper needs to access the Managed Object Browser on the VMware hosts in order to scan this information. The credential which has read-only access to the Managed Object Browser needs to be entered in Lansweeper and mapped to the host machine.

If you need further support with setting this up, we recommend that you send a mail to our support.

Note: In order to scan the guest machines, the VMware view agent needs to be installed on them.

[Srikanth08]

It is showing no data found when i open that report..but we are having so many vmware machines

[Susan_A]

Could you please clarify what exactly is wrong with the report or in what way it isn't working. We don't see anything wrong with the SQL query.

[Srikanth08]

Hi,

iam asking this report "Vmware: Virtual Guest Machines"

[Susan_A]

Which report are you referring to? If you are referring to the "Vmware: less than 10% partition free" one, please try the SQL query below instead. (We are aware that the built-in SQL is not compatible with all Lansweeper installations. We'll fix this in an update.)

Select Top 1000000 tblVmwareDisk.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblVmwareDisk.Name As PartitionName,
  Ceiling(tblVmwareDisk.TotalSpace / 1024 / 1024) As SizeMB,
  Ceiling(tblVmwareDisk.FreeSpace / 1024 / 1024) As FreeMB,
  tblVmwareDisk.Url,
  Ceiling(tblVmwareDisk.FreeSpace / (Case tblVmwareDisk.TotalSpace When 0 Then 1
    Else tblVmwareDisk.TotalSpace End) * 100) As FreePCT
From tblVmwareDisk
  Inner Join tblAssets On tblVmwareDisk.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where Ceiling(tblVmwareDisk.FreeSpace / (Case tblVmwareDisk.TotalSpace
    When 0 Then 1 Else tblVmwareDisk.TotalSpace
  End) * 100) < 20 And tblAssetCustom.State = 1
Order By tblAssets.AssetName