turbot/azure_insights

Query: sql_database_geo_redundant_backup_status

Usage

powerpipe query azure_insights.query.sql_database_geo_redundant_backup_status

Steampipe Tables

SQL

select
geo_redundant_backup_status,
count(*)
from (
select
case
when
retention_policy_property ->> 'monthlyRetention' <> 'PT0S'
or retention_policy_property ->> 'weeklyRetention' <> 'PT0S'
or retention_policy_property ->> 'yearlyRetention' <> 'PT0S' then 'enabled'
else 'disabled'
end geo_redundant_backup_status
from
azure_sql_database) as s
group by
geo_redundant_backup_status
order by
geo_redundant_backup_status;

Dashboards

The query is used in the dashboards: