Notification

Icon
Error

Virtual machines and their host

Posted: Tuesday, January 22, 2019 10:37:31 AM(UTC)
Esben.D

Esben.D

Member Administration Original PosterPosts: 1,738
3
Like
The report below will show all virtual machines and their hosts.


The report will only list assets that meet all of the following criteria:
  • You are running Lansweeper 7
  • The asset state is set to active.
  • Your ESXi hosts are directly scanned or via vCenter scanning
Code:
Select Distinct Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tblVmwareGuest.Ipv4Address,
  tblAssets1.AssetName As Host,
  tblAssets1.IPAddress As HostIP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssets
  Inner Join tblVmwareGuest On tblAssets.AssetID = tblVmwareGuest.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join tblVmwareInfo On tblVmwareGuest.HostID = tblVmwareInfo.VmwareID
  Left Join tblAssets tblAssets1 On tblAssets1.AssetID = tblVmwareInfo.AssetID
Where tblState.Statename = 'Active'
Order By tblVmwareGuest.Ipv4Address,
  tblAssets.AssetName
RayHeathTSS
#1RayHeathTSS Member Posts: 5  
posted: 2/22/2019 6:00:01 PM(UTC)
This only returned VMWare Guests and Hosts.

Can this be easily modified to also include HyperV?
it@gacr.cz
#2it@gacr.cz Member Posts: 1  
posted: 2/25/2019 1:56:40 PM(UTC)
I would also appreciate report for HyperV hosts.
ajokerst
#3ajokerst Member Posts: 6  
posted: 3/6/2019 7:57:44 PM(UTC)
I would also like the Hyper-V report
b.c
#4b.c Member Posts: 1  
posted: 3/28/2019 9:14:29 PM(UTC)
Add another that would like to see a Hyper-V report for hosts and associated guests.

Active Discussions

Lansweeper Pushing Packages in Multi-Domain Trusted Environment
by  SPedraza   Go to last post Go to first unread
Last post: Yesterday at 5:43:05 PM(UTC)
Lansweeper Lansweeper Not Saving New Asset
by  Terry1337  
Go to last post Go to first unread
Last post: Yesterday at 3:52:51 PM(UTC)
Lansweeper Email configuration
by  Ian.Prentice   Go to last post Go to first unread
Last post: Yesterday at 3:14:04 PM(UTC)
Lansweeper InTune Scanning not showing all devices
by  TBRIT  
Go to last post Go to first unread
Last post: Yesterday at 3:12:03 PM(UTC)
Lansweeper Unique Custom Fields
by  Hendrik.VE   Go to last post Go to first unread
Last post: Yesterday at 11:52:35 AM(UTC)
Lansweeper Uptime incorrect
by  alfiet  
Go to last post Go to first unread
Last post: Yesterday at 10:53:33 AM(UTC)
Lansweeper Lansweeper Remote Screenshot Folder
by  Esben.D   Go to last post Go to first unread
Last post: Yesterday at 10:24:31 AM(UTC)
Lansweeper Lansweeper Enterprise optional?
by  Esben.D  
Go to last post Go to first unread
Last post: Yesterday at 10:00:22 AM(UTC)