turbot/aws_thrifty

GitHub

Query: old_ebs_snapshots

Usage

steampipe query aws_thrifty.query.old_ebs_snapshots

Plugins & Tables

SQL

select
'arn:' || partition || ':ec2:' || region || ':' || account_id || ':snapshot/' || snapshot_id as resource,
case
when start_time > current_timestamp - ($1 || ' days')::interval then 'ok'
else 'alarm'
end as status,
snapshot_id || ' created at ' || start_time || '.' as reason,
region,
account_id
from
aws_ebs_snapshot

Controls

The query is being used by the following controls: