turbot/azure_compliance

Query: sql_server_transparent_data_encryption_enabled

Usage

powerpipe query azure_compliance.query.sql_server_transparent_data_encryption_enabled

SQL

select
db.id as resource,
case
when transparent_data_encryption ->> 'status' = 'Disabled' then 'alarm'
else 'ok'
end as status,
case
when transparent_data_encryption ->> 'status' = 'Disabled' then db.name || ' transparent data encryption off.'
else db.name || ' transparent data encryption on.'
end as reason
, db.resource_group as resource_group
, sub.display_name as subscription
from
azure_sql_database db,
azure_subscription sub
where
sub.subscription_id = db.subscription_id;

Controls

The query is being used by the following controls: