turbot/aws_thrifty

GitHub

Query: large_ec2_instances

Usage

steampipe query aws_thrifty.query.large_ec2_instances

Plugins & Tables

SQL

select
arn as resource,
case
when instance_state not in ('running', 'pending', 'rebooting') then 'info'
when instance_type like any ($1) then 'ok'
else 'alarm'
end as status,
title || ' has type ' || instance_type || ' and is ' || instance_state || '.' as reason,
region,
account_id
from
aws_ec2_instance;

Controls

The query is being used by the following controls: