steampipe plugin install aws

Table: aws_health_affected_entity - Query AWS Health Affected Entities using SQL

AWS Health Affected Entities are items that are impacted by events. These entities can include AWS accounts, services, and other AWS resources. They provide valuable information to help you analyze and respond to service health notifications, making it easier to manage events and improve the resiliency of your applications.

Table Usage Guide

The aws_health_affected_entity table in Steampipe provides you with detailed information about entities affected by AWS Health events. This table allows you, as a system administrator or DevOps engineer, to query entity-specific details, including entity ARN, event ARN, status, last updated time, and associated tags. You can utilize this table to gain insights into the health status of AWS resources, enabling proactive monitoring and maintenance. The schema outlines the various attributes of the affected entity for you, such as entity ARN, event ARN, entity value, last updated time, status, and tags.

Examples

Basic info

Explore which AWS health events have impacted your resources. This can help you understand the status and last updated time of each affected entity, providing valuable insights for incident response and recovery.

select
arn,
entity_url,
entity_value,
event_arn,
last_updated_time,
status_code
from
aws_health_affected_entity;
select
arn,
entity_url,
entity_value,
event_arn,
last_updated_time,
status_code
from
aws_health_affected_entity;

List affected entities that are unimpaired

Determine the areas in which entities within the AWS Health service are functioning without impairment. This information can be useful for ensuring system stability and identifying areas of consistent performance.

select
arn,
entity_url,
entity_value,
event_arn,
last_updated_time,
status_code
from
aws_health_affected_entity
where
status_code = 'UNIMPAIRED';
select
arn,
entity_url,
entity_value,
event_arn,
last_updated_time,
status_code
from
aws_health_affected_entity
where
status_code = 'UNIMPAIRED';

Get health event details of each entity

Explore the health status of various entities to gain insights into any potential issues or disruptions. This is particularly useful for proactive problem management and maintaining optimal system health.

select
e.arn,
e.entity_url,
e.event_arn,
v.event_type_category,
v.event_type_code v.service
from
aws_health_affected_entity as e,
aws_health_event as v;
select
e.arn,
e.entity_url,
e.event_arn,
v.event_type_category,
v.event_type_code,
v.service
from
aws_health_affected_entity as e,
aws_health_event as v;

Schema for aws_health_affected_entity

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
arntext=The Amazon Resource Name (ARN) of the health entity.
entity_urltextThe URL of the affected entity.
entity_valuetext=The ID of the affected entity.
event_arntext=The Amazon Resource Name (ARN) of the health event.
last_updated_timetimestamp with time zone>, >=, <, <=, =The most recent time that the entity was updated.
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.
status_codetext=The most recent status of the entity affected by the event. The possible values are IMPAIRED, UNIMPAIRED, and UNKNOWN.
tagsjsonbA map of tags for the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_health_affected_entity