library
turbot/aws_thrifty

Detect & correct large EC2 instances

Overview

EC2 instances can be quite costly to retain, it is also likely that after a certain point in time they're no longer required and should be cleaned up to prevent further costs. Large EC2 instances are unusual, expensive and should be reviewed.

This query trigger detects large EC2 instances and then either sends a notification or attempts to perform a predefined corrective action.

Getting Started

By default, this trigger is disabled, however it can be configred by setting the below variables

  • ec2_instances_large_trigger_enabled should be set to true as the default is false.
  • ec2_instances_large_trigger_schedule should be set to your desired running schedule
  • ec2_instances_large_default_action should be set to your desired action (i.e. "notify" for notifications or "terminate_instance" to delete the instance).

Then starting the server:

flowpipe server

or if you've set the variables in a .fpvars file:

flowpipe server --var-file=/path/to/your.fpvars

Query

select
concat(instance_id, ' [', region, '/', account_id, ']') as title,
instance_id,
region,
_ctx ->> 'connection_name' as cred
from
aws_ec2_instance
where
instance_state in ('running', 'pending', 'rebooting')
and instance_type not like any (
array [ '%.nano',
'%.micro',
'%.small',
'%.medium',
'%.large',
'%.xlarge',
'%._xlarge' ]
)

Schedule

15m