steampipe plugin install awssteampipe plugin install aws

Table: aws_ec2_application_load_balancer

Application load balancers support content-based routing, and supports applications that run in containers and also provide additional visibility into the health of the target instances and containers.

Examples

Security group attached to the application load balancers

select
  name,
  jsonb_array_elements_text(security_groups) as attached_security_group
from
  aws_ec2_application_load_balancer;

Availability zone information

select
  name,
  az ->> 'LoadBalancerAddresses' as load_balancer_addresses,
  az ->> 'OutpostId' as outpost_id,
  az ->> 'SubnetId' as subnet_id,
  az ->> 'ZoneName' as zone_name
from
  aws_ec2_application_load_balancer
  cross join jsonb_array_elements(availability_zones) as az;

List of application load balancers whose availability zone count is less than 1

select
  name,
  count(az ->> 'ZoneName') < 2 as zone_count_1
from
  aws_ec2_application_load_balancer
  cross join jsonb_array_elements(availability_zones) as az
group by
  name;

List of application load balancers whose logging is not enabled

select
  name,
  lb ->> 'Key' as logging_key,
  lb ->> 'Value' as logging_value
from
  aws_ec2_application_load_balancer
  cross join jsonb_array_elements(load_balancer_attributes) as lb
where
  lb ->> 'Key' = 'access_logs.s3.enabled'
  and lb ->> 'Value' = 'false';

List of application load balancers whose deletion protection is not enabled

select
  name,
  lb ->> 'Key' as deletion_protection_key,
  lb ->> 'Value' as deletion_protection_value
from
  aws_ec2_application_load_balancer
  cross join jsonb_array_elements(load_balancer_attributes) as lb
where
  lb ->> 'Key' = 'deletion_protection.enabled'
  and lb ->> 'Value' = 'false';

Query examples

Control examples

.inspect aws_ec2_application_load_balancer

AWS EC2 Application Load Balancer

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
arn	text	The Amazon Resource Name (ARN) of the load balancer.
availability_zones	jsonb	The subnets for the load balancer.
canonical_hosted_zone_id	text	The ID of the Amazon Route 53 hosted zone associated with the load balancer.
created_time	timestamp with time zone	The date and time the load balancer was created.
customer_owned_ipv4_pool	text	The ID of the customer-owned address pool.
dns_name	text	The public DNS name of the load balancer.
ip_address_type	text	The type of IP addresses used by the subnets for your load balancer.
load_balancer_attributes	jsonb	The AWS account ID of the image owner.
name	text	The friendly name of the Load Balancer that was provided during resource creation.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
scheme	text	The load balancing scheme of load balancer.
security_groups	jsonb	The IDs of the security groups for the load balancer.
state_code	text	Current state of the load balancer.
state_reason	text	A description of the state.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags attached to the load balancer.
title	text	Title of the resource.
type	text	The type of load balancer.
vpc_id	text	The ID of the VPC for the load balancer.

turbot/aws