Query: VPC subnet auto assign public IP should be disabled

Description

Ensure that AWS Virtual Private Cloud (AWS VPC) subnets are assigned a public IP address. The control is compliant if AWS VPC does not have subnets that are assigned a public IP address. The control is non-compliant if AWS VPC has subnets that are assigned a public IP address.

Query

Tables used in this query:

• aws_vpc_subnet

Controls using this query:

• 15 EC2 subnets should not automatically assign public IP addresses
• VPC subnet auto assign public IP should be disabled

SQL