turbot/oci_insights

Query: database_autonomous_db_data_guard_status

Usage

powerpipe query oci_insights.query.database_autonomous_db_data_guard_status

SQL

with dataguard_stat as (
select
case
when is_data_guard_enabled then 'enabled'
else 'disabled'
end as dataguard_stat
from
oci_database_autonomous_database
)
select
dataguard_stat,
count(*)
from
dataguard_stat
group by dataguard_stat

Dashboards

The query is used in the dashboards: