Control: Old snapshots should be deleted if not required
Description
Old snapshots are likely unneeded and costly to maintain.
Usage
Run the control in your terminal:
powerpipe control run azure_thrifty.control.compute_snapshot_max_ageSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run azure_thrifty.control.compute_snapshot_max_age --shareSteampipe Tables
Params
| Args | Name | Default | Description | Variable |
|---|---|---|---|---|
| $1 | compute_snapshot_age_max_days | | The maximum number of days snapshots can be retained. |
SQL
select s.unique_id as resource, case when date_part('day', now()-time_created) < $1 then 'ok' else 'alarm' end as status, s.title || ' created at ' || time_created || ' (' || date_part('day', now() - time_created) || ' days).' as reason , s.resource_group , display_name as subscriptionfrom azure_compute_snapshot as s, azure_subscription as subwhere sub.subscription_id = s.subscription_id;