steampipe plugin install awssteampipe plugin install aws

Table: aws_elastic_beanstalk_environment

AWS Elastic Beanstalk makes it easy to create new environments for your application. You can create and manage separate environments for development, testing, and production use, and you can deploy any version of your application to any environment. Environments can be long-running or temporary. When you terminate an environment, you can save its configuration to recreate it later.

Examples

Basic info

select
  environment_id,
  environment_name,
  application_name,
  arn,
  tier
from
  aws_elastic_beanstalk_environment;

List environments which have configuration updates and application version deployments in progress

select
  environment_name,
  abortable_operation_in_progress
from
  aws_elastic_beanstalk_environment
where
  abortable_operation_in_progress = 'true';

List unhealthy environments

select
  environment_name,
  application_name,
  environment_id,
  health
from
  aws_elastic_beanstalk_environment
where
  health = 'Red';

List environments with health monitoring disabled

select
  environment_name,
  health_status
from
  aws_elastic_beanstalk_environment
where
  health_status = 'Suspended';

List managed actions for each environment

select
  environment_name,
  a ->> 'ActionDescription' as action_description,
  a ->> 'ActionId' as action_id,
  a ->> 'ActionType' as action_type,
  a ->> 'Status' as action_status,
  a ->> 'WindowStartTime' as action_window_start_time
from
  aws_elastic_beanstalk_environment,
  jsonb_array_elements(managed_actions) as a;

Control examples

.inspect aws_elastic_beanstalk_environment

AWS ElasticBeanstalk Environment

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
abortable_operation_in_progress	boolean	Indicates if there is an in-progress environment configuration update or application version deployment that you can cancel.
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.
application_name	text	The name of the application associated with this environment.
arn	text	The environment's Amazon Resource Name (ARN).
cname	text	The URL to the CNAME for this environment.
date_created	timestamp with time zone	The creation date for this environment.
date_updated	timestamp with time zone	The last modified date for this environment.
description	text	Describes this environment.
endpoint_url	text	The URL to the LoadBalancer.
environment_id	text	The ID of this environment.
environment_links	jsonb	A list of links to other environments in the same group.
environment_name	text	The name of this environment.
health	text	The health status of the environment.
health_status	text	Returns the health status of the application running in your environment.
managed_actions	jsonb	A list of upcoming and in-progress managed actions.
operations_role	text	The Amazon Resource Name (ARN) of the environment's operations role.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
platform_arn	text	The ARN of the platform version.
region	text	The AWS Region in which the resource is located.
resources	jsonb	The description of the AWS resources used by this environment.
solution_stack_name	text	The name of the SolutionStack deployed with this environment.
status	text	The current operational status of the environment.
tags	jsonb
tags_src	jsonb	A list of tags assigned to the Repository
template_name	text	The name of the configuration template used to originally launch this environment.
tier	jsonb	Describes the current tier of this environment.
title	text	Title of the resource.
version_label	text	The application version deployed in this environment.

turbot/aws