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,632
2
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 Fonts
by  TKinnie   Go to last post Go to first unread
Last post: Today at 4:00:40 PM(UTC)
Action Schedule Reboot using AT and psshutdown with time input
by  spatchE  
Go to last post Go to first unread
Last post: 5/21/2019 5:35:46 PM(UTC)
Action Open users local Temp directory
by  studerje   Go to last post Go to first unread
Last post: 5/14/2019 7:24:24 PM(UTC)
Lansweeper CMD- CFI MS Update remover 2
by  Rodney Stowell   Go to last post Go to first unread
Last post: 4/18/2019 6:55:01 PM(UTC)
Action Skype User
by  cctech  
Go to last post Go to first unread
Last post: 4/18/2019 4:14:54 PM(UTC)
Action Email user
by  cctech   Go to last post Go to first unread
Last post: 4/18/2019 3:48:50 PM(UTC)
Lansweeper RDP to the asset
by  AZHockeyNut  
Go to last post Go to first unread
Last post: 4/9/2019 6:31:48 PM(UTC)