Notification

Icon
Error

AWS: Subnets (Built-in)

Posted: Tuesday, March 5, 2019 1:16:29 PM(UTC)
Esben.D

Esben.D

Member Administration Original PosterPosts: 1,827
0
Like
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.

Code:
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

Active Discussions

Lansweeper Windows 7 EOL
by  Esben.D   Go to last post Go to first unread
Last post: Today at 12:22:43 PM(UTC)
Lansweeper Change History or Restore of Custom Reports?
by  Esben.D  
Go to last post Go to first unread
Last post: Today at 12:16:21 PM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  Esben.D   Go to last post Go to first unread
Last post: Today at 10:55:07 AM(UTC)
Action Change Windows domain PC Name
by  max204  
Go to last post Go to first unread
Last post: Today at 10:28:29 AM(UTC)
Lansweeper Lansweeper Reporting Old Assets as New
by  Esben.D   Go to last post Go to first unread
Last post: Today at 8:45:09 AM(UTC)
Lansweeper Thunderbird 68 Vulnerability
by  Esben.D  
Go to last post Go to first unread
Last post: Today at 8:41:29 AM(UTC)
Lansweeper Assets disappearing
by  Leeroy_J   Go to last post Go to first unread
Last post: Today at 12:44:56 AM(UTC)
Lansweeper Old Windows 7 Assets
by  cycleheat  
Go to last post Go to first unread
Last post: Yesterday at 9:45:35 PM(UTC)