turbot/azure_insights

Query: sql_database_tde_status

Usage

powerpipe query azure_insights.query.sql_database_tde_status

Steampipe Tables

SQL

select
tde_status,
count(*)
from (
select
case when transparent_data_encryption ->> 'status' <> 'Enabled' then 'disabled'
else 'enabled'
end tde_status
from
azure_sql_database) as s
group by
tde_status
order by
tde_status;

Dashboards

The query is used in the dashboards: