turbot/oci_insights

Query: database_autonomous_db_by_operations_insights_status

Usage

powerpipe query oci_insights.query.database_autonomous_db_by_operations_insights_status

SQL

select
insight_status,
count(*)
from
(
select
operations_insights_status,
case
when operations_insights_status = 'NOT_ENABLED' then 'disabled'
else 'enabled'
end insight_status
from
oci_database_autonomous_database
) as t
group by
insight_status
order by
insight_status desc;

Dashboards

The query is used in the dashboards: