Control: Database clusters created over 90 days ago should be reviewed
Description
Database clusters created over 90 days ago should be reviewed and deleted if not required.
Usage
Run the control in your terminal:
powerpipe control run digitalocean_thrifty.control.database_long_running
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run digitalocean_thrifty.control.database_long_running --share
Steampipe Tables
SQL
select d.urn as resource, case when date_part('day', now() - d.created_at) > $1 then 'alarm' else 'ok' end as status, d.title || ' of ' || d.engine || ' type in use for ' || date_part('day', now() - d.created_at) || ' day(s).' as reason , r.name as region from digitalocean_database as d left join digitalocean_region as r on r.slug = d.region_slug;
Params
Args | Name | Default | Description | Variable |
---|---|---|---|---|
$1 | database_age_max_days |
| The maximum number of days databases are allowed to run. |