library
turbot/aws_thrifty

Detect & correct EC2 instances exceeding max age

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.

This query trigger detects unused 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_exceeding_max_age_trigger_enabled should be set to true as the default is false.
  • ec2_instances_exceeding_max_age_trigger_schedule should be set to your desired running schedule
  • ec2_instances_exceeding_max_age_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
date_part('day', now() - launch_time) > 90
and instance_state in ('running', 'pending', 'rebooting')

Schedule

15m