Notification

Icon
Error

AWS: Number of instances per region (Built-in)

Posted: Tuesday, March 5, 2019 1:19:11 PM(UTC)
Esben.D

Esben.D

Member Administration Original PosterPosts: 1,676
0
Like
The report below gives back a count of the AWS Instances per region.

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

Code:
Select Top 1000000 tblAWSInstance.Region,
  Count(tblAWSInstance.Region) As #OfInstances
From tblAWSInstance
Group By tblAWSInstance.Region
Order By #OfInstances Desc
Options

Active Discussions

Lansweeper Add Document as File Link
by  AZHockeyNut   Go to last post Go to first unread
Last post: Today at 3:18:49 PM(UTC)
Lansweeper LsAgent install issue
by  moug   Go to last post Go to first unread
Last post: Today at 3:12:47 PM(UTC)
Lansweeper Spare Hard Drives
by  brodiemac   Go to last post Go to first unread
Last post: Today at 2:32:31 PM(UTC)
Lansweeper Serial no of Dell Monitor are not scanned as per assest tag
by  atul557   Go to last post Go to first unread
Last post: Today at 1:06:03 PM(UTC)
Lansweeper Adding Events via Meeting Request
by  Esben.D   Go to last post Go to first unread
Last post: Today at 10:32:17 AM(UTC)
Lansweeper Same Name and Domain
by  Esben.D   Go to last post Go to first unread
Last post: Today at 10:26:22 AM(UTC)
Lansweeper Logs of User activity
by  Esben.D   Go to last post Go to first unread
Last post: Today at 9:50:00 AM(UTC)
Lansweeper O365 scanning issue
by  Esben.D   Go to last post Go to first unread
Last post: Today at 9:44:35 AM(UTC)