cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Esben_D
Lansweeper Employee
Lansweeper Employee
The report below gives back a list of AWS subnets.

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

Select Top 1000000 tblAWSSubnet.SubnetId,
tblAWSSubnet.VPCId,
tblAWSSubnet.AvailabilityZone,
tblAWSSubnet.AvailableIpAddressCount,
tblAWSSubnet.DefaultForAz,
tblAWSSubnet.State,
tblAWSSubnet.CidrBlock,
tblAWSSubnetIpv6CidrBlock.Ipv6CidrBlock,
tblAWSSubnetIpv6CidrBlock.State As Ipv6CidrState
From tblAWSSubnet
Left Join tblAWSSubnetIpv6CidrBlock On tblAWSSubnetIpv6CidrBlock.AWSSubnetId =
tblAWSSubnet.AWSSubnetId
Order By tblAWSSubnet.AvailabilityZone,
tblAWSSubnet.VPCId,
tblAWSSubnet.SubnetId
0 REPLIES 0