turbot/gcp_insights

Query: sql_database_instance_point_in_time_recovery_status

Usage

powerpipe query gcp_insights.query.sql_database_instance_point_in_time_recovery_status

SQL

select
point_in_time_recovery_status,
count(*)
from
(
select
name,
case
when enable_point_in_time_recovery then 'enabled'
else 'disabled'
end point_in_time_recovery_status
from
gcp_sql_database_instance
) as c
group by
point_in_time_recovery_status
order by
point_in_time_recovery_status;

Dashboards

The query is used in the dashboards: