turbot/digitalocean_insights

Query: droplet_by_ssl_status

Usage

powerpipe query digitalocean_insights.query.droplet_by_ssl_status

Steampipe Tables

SQL

with database as (
select
case
when not connection_ssl
and not private_connection_ssl then 'disabled'
else 'enabled'
end as ssl_status
from
digitalocean_database
)
select
ssl_status,
count(*) as "Clusters"
from
database
group by
ssl_status;

Dashboards

The query is used in the dashboards: