03-05-2019 01:16 PM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now