steampipe plugin install awssteampipe plugin install aws

Table: aws_ec2_classic_load_balancer

Classic Load Balancer provides basic load balancing across multiple Amazon EC2 instances and operates at both the request level and connection level. Classic Load Balancer is intended for applications that are built within the EC2-Classic network.

Examples

Instances associated with classic load balancers

select
  name,
  instances
from
  aws_ec2_classic_load_balancer;

List of classic load balancers whose logging is not enabled

select
  name,
  access_log_enabled
from
  aws_ec2_classic_load_balancer
where
  access_log_enabled = 'false';

Security groups attached to each classic load balancer

select
  name,
  jsonb_array_elements_text(security_groups) as sg
from
  aws_ec2_classic_load_balancer;

Classic load balancers listener info

select
  name,
  listener_description -> 'Listener' ->> 'InstancePort' as instance_port,
  listener_description -> 'Listener' ->> 'InstanceProtocol' as instance_protocol,
  listener_description -> 'Listener' ->> 'LoadBalancerPort' as load_balancer_port,
  listener_description -> 'Listener' ->> 'Protocol' as load_balancer_protocol,
  listener_description -> 'SSLCertificateId' ->> 'SSLCertificateId' as ssl_certificate,
  listener_description -> 'Listener' ->> 'PolicyNames' as policy_names
from
  aws_ec2_classic_load_balancer
  cross join jsonb_array_elements(listener_descriptions) as listener_description;

Health check info

select
  name,
  healthy_threshold,
  health_check_interval,
  health_check_target,
  health_check_timeout,
  unhealthy_threshold
from
  aws_ec2_classic_load_balancer;

Query examples

Control examples

.inspect aws_ec2_classic_load_balancer

AWS EC2 Classic Load Balancer

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
access_log_emit_interval	bigint	The interval for publishing the access logs.
access_log_enabled	boolean	Specifies whether access logs are enabled for the load balancer.
access_log_s3_bucket_name	text	The name of the Amazon S3 bucket where the access logs are stored.
access_log_s3_bucket_prefix	text	The logical hierarchy you created for your Amazon S3 bucket.
account_id	text	The AWS Account ID in which the resource is located.
additional_attributes	jsonb	A list of additional attributes.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
app_cookie_stickiness_policies	jsonb	A list of the stickiness policies created using CreateAppCookieStickinessPolicy.
arn	text	The Amazon Resource Name (ARN) specifying the classic load balancer.
availability_zones	jsonb	A list of the Availability Zones for the load balancer.
backend_server_descriptions	jsonb	A list of information about your EC2 instances.
canonical_hosted_zone_name	text	The name of the Amazon Route 53 hosted zone for the load balancer.
canonical_hosted_zone_name_id	text	The ID of the Amazon Route 53 hosted zone for the load balancer.
connection_draining_enabled	boolean	Specifies whether connection draining is enabled for the load balancer.
connection_draining_timeout	bigint	The maximum time, in seconds, to keep the existing connections open before deregistering the instances.
connection_settings_idle_timeout	bigint	The time, in seconds, that the connection is allowed to be idle (no data has been sent over the connection) before it is closed by the load balancer.
created_time	timestamp with time zone	The date and time the load balancer was created.
cross_zone_load_balancing_enabled	boolean	Specifies whether cross-zone load balancing is enabled for the load balancer.
dns_name	text	The DNS name of the load balancer.
health_check_interval	bigint	The approximate interval, in seconds, between health checks of an individual instance.
health_check_target	text	The instance being checked. The protocol is either TCP, HTTP, HTTPS, or SSL. The range of valid ports is one (1) through 65535.
health_check_timeout	bigint	The amount of time, in seconds, during which no response means a failed health check.
healthy_threshold	bigint	The number of consecutive health checks successes required before moving the instance to the Healthy state.
instances	jsonb	A list of the IDs of the instances for the load balancer.
lb_cookie_stickiness_policies	jsonb	A list of the stickiness policies created using CreateLBCookieStickinessPolicy.
listener_descriptions	jsonb	A list of the listeners for the load balancer
name	text	The friendly name of the Load Balancer.
other_policies	jsonb	A list of policies other than the stickiness policies.
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	A list of the security groups for the load balancer.
source_security_group_name	text	The name of the security group.
source_security_group_owner_alias	text	The owner of the security group.
subnets	jsonb	A list of the IDs of the subnets for the load balancer.
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.
unhealthy_threshold	bigint	The number of consecutive health check failures required before moving the instance to the Unhealthy state.
vpc_id	text	The ID of the VPC for the load balancer.

turbot/aws