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

[Esben_D]

The report below gives back a count of the AWS Instances per VPC.

The report will only list VPCs when the following criteria are met:

• You have Lansweeper 7.1 or higher.
  
• There is AWS VPC and Instance data scanned.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName As VPC,
  Count(tblAWSInstance.AWSInstanceId) As #OfInstances
From tblAssets
  Inner Join tblAWSContainer On tblAWSContainer.AssetID = tblAssets.AssetID
  Inner Join tblAWSInstance On tblAWSInstance.AWSContainerId =
    tblAWSContainer.AWSContainerId
Where (tblAWSContainer.VpcId != '' Or tblAWSContainer.VpcId != Null)
Group By tblAssets.AssetID,
  tblAssets.AssetName
Order By #OfInstances Desc