turbot/digitalocean_insights

Query: droplet_by_monitoring_status

Usage

powerpipe query digitalocean_insights.query.droplet_by_monitoring_status

Steampipe Tables

SQL

with droplets as (
select
case
when not features ? 'monitoring' then 'disabled'
else 'enabled'
end as backup_status
from
digitalocean_droplet
)
select
backup_status,
count(*) as "Droplets"
from
droplets
group by
backup_status;

Dashboards

The query is used in the dashboards: