AWS: Subnets (Built-in)

[Esben_D]

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