Notification

Icon
Error

AWS: Dedicated Hosts (Built-in)

Posted: Tuesday, March 5, 2019 1:21:22 PM(UTC)
Esben.D

Esben.D

Member Administration Original PosterPosts: 2,186
0
Like
The report below gives back a list of AWS dedicated hosts

The report will only list assets when the following criteria are met:
  • You have Lansweeper 7.1 or higher.
  • There is AWS dedicated host data scanned

Code:
Select Top 1000000 tblAWSHost.HostId,
  tblAWSHost.InstanceType,
  tblAWSHost.State,
  tblAWSHost.AvailabilityZone,
  tblAWSHost.AutoPlacement,
  tblAWSHost.TotalVCpus,
  tblAWSHost.AvailableVCpus,
  tblAWSHost.Cores,
  tblAWSHost.Sockets,
  tblAWSHost.ReleaseTime,
  tblAWSHost.LastChanged
From tblAWSHost
Order By tblAWSHost.HostId

Active Discussions

Lansweeper Exclude non-windows assets from scanning by assetname
by  rapheren   Go to last post Go to first unread
Last post: Today at 1:18:12 PM(UTC)
Lansweeper HTTPS Certifikate untrusted
by  pskup  
Go to last post Go to first unread
Last post: Today at 9:20:07 AM(UTC)
Lansweeper Migrate to new host but without SQL
by  pskup   Go to last post Go to first unread
Last post: Today at 9:03:14 AM(UTC)
Lansweeper Object reference error after updating to 10.2.0.0
by  Erik.T  
Go to last post Go to first unread
Last post: Today at 8:10:25 AM(UTC)
Lansweeper Detect Docking Stations
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 12:59:42 AM(UTC)
Lansweeper Custom reporting - Asset Groups and AD Description
by  rbshawn  
Go to last post Go to first unread
Last post: Yesterday at 10:54:10 PM(UTC)
Lansweeper A FIX for an odd Scan Error WMI/DCOM from scanning server
by  danielm   Go to last post Go to first unread
Last post: Yesterday at 10:14:44 PM(UTC)
Lansweeper Purging helpdesk tickets older than 5 years
by  SentryP  
Go to last post Go to first unread
Last post: Yesterday at 6:13:37 PM(UTC)