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

[Esben_D]

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.

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