steampipe plugin install awssteampipe plugin install aws
aws_accessanalyzer_analyzeraws_accountaws_acm_certificateaws_api_gateway_api_keyaws_api_gateway_authorizeraws_api_gateway_rest_apiaws_api_gateway_stageaws_api_gateway_usage_planaws_api_gatewayv2_apiaws_api_gatewayv2_domain_nameaws_api_gatewayv2_integrationaws_api_gatewayv2_stageaws_appautoscaling_targetaws_auditmanager_assessmentaws_auditmanager_controlaws_auditmanager_evidenceaws_auditmanager_evidence_folderaws_auditmanager_frameworkaws_availability_zoneaws_backup_planaws_backup_selectionaws_backup_vaultaws_cloudformation_stackaws_cloudfront_cache_policyaws_cloudfront_distributionaws_cloudfront_origin_access_identityaws_cloudfront_origin_request_policyaws_cloudtrail_trailaws_cloudwatch_alarmaws_cloudwatch_log_groupaws_cloudwatch_log_metric_filteraws_cloudwatch_log_streamaws_codebuild_projectaws_codebuild_source_credentialaws_codecommit_repositoryaws_codepipeline_pipelineaws_config_configuration_recorderaws_config_conformance_packaws_config_ruleaws_cost_by_account_dailyaws_cost_by_account_monthlyaws_cost_by_service_dailyaws_cost_by_service_monthlyaws_cost_by_service_usage_type_dailyaws_cost_by_service_usage_type_monthlyaws_cost_forecast_dailyaws_cost_forecast_monthlyaws_cost_usageaws_dax_clusteraws_dms_replication_instanceaws_dynamodb_backupaws_dynamodb_global_tableaws_dynamodb_metric_account_provisioned_read_capacity_utilaws_dynamodb_metric_account_provisioned_write_capacity_utilaws_dynamodb_tableaws_ebs_snapshotaws_ebs_volumeaws_ebs_volume_metric_read_opsaws_ebs_volume_metric_read_ops_dailyaws_ebs_volume_metric_read_ops_hourlyaws_ebs_volume_metric_write_opsaws_ebs_volume_metric_write_ops_dailyaws_ebs_volume_metric_write_ops_hourlyaws_ec2_amiaws_ec2_ami_sharedaws_ec2_application_load_balanceraws_ec2_autoscaling_groupaws_ec2_classic_load_balanceraws_ec2_gateway_load_balanceraws_ec2_instanceaws_ec2_instance_availabilityaws_ec2_instance_metric_cpu_utilizationaws_ec2_instance_metric_cpu_utilization_dailyaws_ec2_instance_metric_cpu_utilization_hourlyaws_ec2_instance_typeaws_ec2_key_pairaws_ec2_launch_configurationaws_ec2_load_balancer_listeneraws_ec2_network_interfaceaws_ec2_network_load_balanceraws_ec2_regional_settingsaws_ec2_ssl_policyaws_ec2_target_groupaws_ec2_transit_gatewayaws_ec2_transit_gateway_route_tableaws_ec2_transit_gateway_vpc_attachmentaws_ecr_repositoryaws_ecrpublic_repositoryaws_ecs_clusteraws_ecs_container_instanceaws_ecs_serviceaws_ecs_task_definitionaws_efs_access_pointaws_efs_file_systemaws_efs_mount_targetaws_eks_addonaws_eks_addon_versionaws_eks_clusteraws_elastic_beanstalk_applicationaws_elastic_beanstalk_environmentaws_elasticache_clusteraws_elasticache_parameter_groupaws_elasticache_replication_groupaws_elasticache_subnet_groupaws_elasticsearch_domainaws_emr_clusteraws_eventbridge_ruleaws_glacier_vaultaws_glue_catalog_databaseaws_guardduty_detectoraws_guardduty_findingaws_guardduty_ipsetaws_guardduty_threat_intel_setaws_iam_access_advisoraws_iam_access_keyaws_iam_account_password_policyaws_iam_account_summaryaws_iam_actionaws_iam_credential_reportaws_iam_groupaws_iam_policyaws_iam_policy_simulatoraws_iam_roleaws_iam_server_certificateaws_iam_useraws_iam_virtual_mfa_deviceaws_inspector_assessment_targetaws_inspector_assessment_templateaws_kinesis_consumeraws_kinesis_firehose_delivery_streamaws_kinesis_streamaws_kinesis_video_streamaws_kinesisanalyticsv2_applicationaws_kms_keyaws_lambda_aliasaws_lambda_functionaws_lambda_versionaws_macie2_classification_jobaws_rds_db_clusteraws_rds_db_cluster_parameter_groupaws_rds_db_cluster_snapshotaws_rds_db_instanceaws_rds_db_instance_metric_connectionsaws_rds_db_instance_metric_connections_dailyaws_rds_db_instance_metric_connections_hourlyaws_rds_db_instance_metric_cpu_utilizationaws_rds_db_instance_metric_cpu_utilization_dailyaws_rds_db_instance_metric_cpu_utilization_hourlyaws_rds_db_instance_metric_read_iopsaws_rds_db_instance_metric_read_iops_dailyaws_rds_db_instance_metric_read_iops_hourlyaws_rds_db_instance_metric_write_iopsaws_rds_db_instance_metric_write_iops_dailyaws_rds_db_instance_metric_write_iops_hourlyaws_rds_db_option_groupaws_rds_db_parameter_groupaws_rds_db_snapshotaws_rds_db_subnet_groupaws_redshift_clusteraws_redshift_event_subscriptionaws_redshift_parameter_groupaws_redshift_snapshotaws_redshift_subnet_groupaws_regionaws_route53_domainaws_route53_recordaws_route53_resolver_endpointaws_route53_resolver_ruleaws_route53_zoneaws_s3_access_pointaws_s3_account_settingsaws_s3_bucketaws_sagemaker_endpoint_configurationaws_sagemaker_modelaws_sagemaker_notebook_instanceaws_sagemaker_training_jobaws_secretsmanager_secretaws_securityhub_hubaws_securityhub_productaws_sns_topicaws_sns_topic_subscriptionaws_sqs_queueaws_ssm_associationaws_ssm_documentaws_ssm_maintenance_windowaws_ssm_managed_instanceaws_ssm_managed_instance_complianceaws_ssm_parameteraws_ssm_patch_baselineaws_vpcaws_vpc_customer_gatewayaws_vpc_dhcp_optionsaws_vpc_egress_only_internet_gatewayaws_vpc_eipaws_vpc_endpointaws_vpc_endpoint_serviceaws_vpc_flow_logaws_vpc_internet_gatewayaws_vpc_nat_gatewayaws_vpc_network_aclaws_vpc_routeaws_vpc_route_tableaws_vpc_security_groupaws_vpc_security_group_ruleaws_vpc_subnetaws_vpc_vpn_connectionaws_vpc_vpn_gatewayaws_waf_rate_based_ruleaws_waf_ruleaws_wafv2_ip_setaws_wafv2_regex_pattern_setaws_wafv2_rule_groupaws_wafv2_web_aclaws_wellarchitected_workload

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,
heath_check_target,
health_check_timeout,
unhealthy_threshold
from
aws_ec2_classic_load_balancer;

.inspect aws_ec2_classic_load_balancer

AWS EC2 Classic Load Balancer

NameTypeDescription
access_log_emit_intervalbigintThe interval for publishing the access logs.
access_log_enabledbooleanSpecifies whether access logs are enabled for the load balancer.
access_log_s3_bucket_nametextThe name of the Amazon S3 bucket where the access logs are stored.
access_log_s3_bucket_prefixtextThe logical hierarchy you created for your Amazon S3 bucket.
account_idtextThe AWS Account ID in which the resource is located.
additional_attributesjsonbA list of additional attributes.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
app_cookie_stickiness_policiesjsonbA list of the stickiness policies created using CreateAppCookieStickinessPolicy.
arntextThe Amazon Resource Name (ARN) specifying the classic load balancer.
availability_zonesjsonbA list of the Availability Zones for the load balancer.
backend_server_descriptionsjsonbA list of information about your EC2 instances.
canonical_hosted_zone_nametextThe name of the Amazon Route 53 hosted zone for the load balancer.
canonical_hosted_zone_name_idtextThe ID of the Amazon Route 53 hosted zone for the load balancer.
connection_draining_enabledbooleanSpecifies whether connection draining is enabled for the load balancer.
connection_draining_timeoutbigintThe maximum time, in seconds, to keep the existing connections open before deregistering the instances.
connection_settings_idle_timeoutbigintThe 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_timetimestamp without time zoneThe date and time the load balancer was created.
cross_zone_load_balancing_enabledbooleanSpecifies whether cross-zone load balancing is enabled for the load balancer.
dns_nametextThe DNS name of the load balancer.
health_check_intervalbigintThe approximate interval, in seconds, between health checks of an individual instance.
health_check_timeoutbigintThe amount of time, in seconds, during which no response means a failed health check.
healthy_thresholdbigintThe number of consecutive health checks successes required before moving the instance to the Healthy state.
heath_check_targettextThe instance being checked.
instancesjsonbA list of the IDs of the instances for the load balancer.
lb_cookie_stickiness_policiesjsonbA list of the stickiness policies created using CreateLBCookieStickinessPolicy.
listener_descriptionsjsonbA list of the listeners for the load balancer
nametextThe friendly name of the Load Balancer.
other_policiesjsonbA list of policies other than the stickiness policies.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
schemetextThe load balancing scheme of load balancer.
security_groupsjsonbA list of the security groups for the load balancer.
source_security_group_nametextThe name of the security group.
source_security_group_owner_aliastextThe owner of the security group.
subnetsjsonbA list of the IDs of the subnets for the load balancer.
tagsjsonbA map of tags for the resource.
tags_srcjsonbA list of tags attached to the load balancer.
titletextTitle of the resource.
unhealthy_thresholdbigintThe number of consecutive health check failures required before moving the instance to the Unhealthy state.
vpc_idtextThe ID of the VPC for the load balancer.