cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Srikanth08
Engaged Sweeper II
Hi,

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

Please help
Regards, Srikanth08
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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.

View solution in original post

5 REPLIES 5
Daniel_B
Lansweeper Alumni
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
Engaged Sweeper II
It is showing no data found when i open that report..but we are having so many vmware machines
Regards, Srikanth08
Susan_A
Lansweeper Alumni
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
Engaged Sweeper II
Hi,

iam asking this report "Vmware: Virtual Guest Machines"
Regards, Srikanth08
Susan_A
Lansweeper Alumni
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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now