→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Esben_D
Lansweeper Employee
Lansweeper Employee
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
0 REPLIES 0