steampipe plugin install aws

Table: aws_health_event - Query AWS Health Events using SQL

The AWS Health Events service provides personalized information about events that can affect your AWS infrastructure, guiding your through scheduled changes, and accelerating troubleshooting. It aggregates and consolidates alerts and notifications from multiple AWS services into a single, easy-to-search interface. AWS Health Events also integrates with AWS Organizations to provide a centralized view of health events across all your accounts.

Table Usage Guide

The aws_health_event table in Steampipe provides you with information about AWS Health Events. These events give you timely information about service disruptions, scheduled changes, and other important AWS-related events that can affect your services and accounts. This table allows you, as a DevOps engineer, to query event-specific details, including event type, start time, end time, and affected services. You can utilize this table to monitor your AWS services, understand the impact of AWS events, and plan necessary actions accordingly. The schema outlines the various attributes of the AWS Health Event for you, including the event ARN, event type category, service, region, start time, and end time.

Examples

Basic info

Explore which events have occurred within your AWS services, pinpointing their specific locations and durations. This can help in assessing the overall health and performance of your AWS infrastructure.

select
arn,
availability_zone,
start_time,
end_time,
event_type_category,
event_type_code,
event_scope_code,
service,
region
from
aws_health_event;
select
arn,
availability_zone,
start_time,
end_time,
event_type_category,
event_type_code,
event_scope_code,
service,
region
from
aws_health_event;

List upcoming events

Gain insights into upcoming events across your AWS services to better prepare and manage your resources. This query is useful for proactive planning and risk mitigation.

select
arn,
start_time,
end_time,
event_type_category,
event_type_code,
event_scope_code,
status_code,
service
from
aws_health_event
where
status_code = 'upcoming';
select
arn,
start_time,
end_time,
event_type_category,
event_type_code,
event_scope_code,
status_code,
service
from
aws_health_event
where
status_code = 'upcoming';

List event details for the EC2 service

Explore the various events related to the EC2 service by analyzing their start and end times, status, and other relevant details. This can help determine any patterns or irregularities in the service's operation, aiding in proactive management and troubleshooting.

select
arn,
start_time,
end_time,
event_type_category,
event_type_code,
event_scope_code,
status_code,
service
from
aws_health_event
where
service = 'EC2';
select
arn,
start_time,
end_time,
event_type_category,
event_type_code,
event_scope_code,
status_code,
service
from
aws_health_event
where
service = 'EC2';

List event details for an availability zone

Gain insights into the specific events occurring within a particular availability zone, enabling you to monitor and manage service health more effectively.

select
arn,
availability_zone,
start_time,
end_time,
event_type_category,
event_type_code,
event_scope_code,
status_code,
service
from
aws_health_event
where
availability_zone = 'us-east-1a';
select
arn,
availability_zone,
start_time,
end_time,
event_type_category,
event_type_code,
event_scope_code,
status_code,
service
from
aws_health_event
where
availability_zone = 'us-east-1a';

Schema for aws_health_event

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 HealthEvent.
availability_zonetext=The Amazon Web Services Availability Zone of the event.
end_timetimestamp with time zone=The date and time that the event ended.
event_scope_codetextThis parameter specifies if the Health event is a public Amazon Web Services service event or an account-specific event.
event_type_categorytext=A list of event type category codes. Possible values are issue, accountNotification, or scheduledChange.
event_type_codetext=The unique identifier for the event type.
last_updated_timetimestamp with time zone=The most recent date and time that the event 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.
servicetext=The Amazon Web Services service that is affected by the event. For example, EC2, RDS.
start_timetimestamp with time zone=The date and time that the event began.
status_codetext=The most recent status of the event. Possible values are open, closed, and upcoming.

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_event