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
