turbot/gcp_insights

Query: sql_database_ssl_status

Usage

powerpipe query gcp_insights.query.sql_database_ssl_status

SQL

select
ssl_status,
count(*)
from (
select name,
case when ip_configuration -> 'requireSsl' is null then
'disabled'
else
'enabled'
end ssl_status
from
gcp_sql_database_instance) as c
group by
ssl_status
order by
ssl_status;

Dashboards

The query is used in the dashboards: