turbot/digitalocean_insights

Query: digitalocean_droplet_age_table

Usage

powerpipe query digitalocean_insights.query.digitalocean_droplet_age_table

Steampipe Tables

SQL

select
name as "Name",
id as "ID",
now() :: date - created_at :: date as "Age in Days",
created_at as "Create Time",
status as "Status",
region ->> 'name' as "Region",
urn as "URN"
from
digitalocean_droplet
order by
name;

Dashboards

The query is used in the dashboards: