steampipe plugin install awssteampipe plugin install aws

Table: aws_ec2_network_load_balancer

AWS Network Load Balancer (NLB) distributes end user traffic across multiple cloud resources to ensure low latency and high throughput for applications. When a target becomes slow or unavailable, the Network Load Balancer routes traffic to another target.

Examples

Security group attached to the network load balancer

select
  name,
  jsonb_array_elements(security_groups) as attached_security_group
from
  aws_ec2_network_load_balancer;

Count of AZs registered with network load balancers

select
  name,
  count(az ->> 'ZoneName') as zone_count
from
  aws_ec2_network_load_balancer
  cross join jsonb_array_elements(availability_zones) as az
group by
  name;

List of network load balancers where Cross-Zone Load Balancing is enabled

select
  name,
  lb ->> 'Key' as cross_zone,
  lb ->> 'Value' as cross_zone_value
from
  aws_ec2_network_load_balancer
  cross join jsonb_array_elements(load_balancer_attributes) as lb
where
  lb ->> 'Key' = 'load_balancing.cross_zone.enabled'
  and lb ->> 'Value' = 'false';

List of network load balancers where logging is not enabled

select
  name,
  lb ->> 'Key' as logging_key,
  lb ->> 'Value' as logging_value
from
  aws_ec2_network_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 network load balancers where deletion protection is not enabled

select
  name,
  lb ->> 'Key' as deletion_protection_key,
  lb ->> 'Value' as deletion_protection_value
from
  aws_ec2_network_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_network_load_balancer

AWS EC2 Network 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
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