turbot/azure_insights

Query: sql_server_encryption

Usage

powerpipe query azure_insights.query.sql_server_encryption

Steampipe Tables

SQL

select
ep ->> 'name' as "Name",
ep ->> 'kind' as "Kind",
ep ->> 'serverKeyName' as "Server Key Name",
ep ->> 'serverKeyType' as "Server Key Type",
ep ->> 'id' as "ID"
from
azure_sql_server,
jsonb_array_elements(encryption_protector) as ep
where
lower(id) = $1
and subscription_id = split_part($1, '/', 3);

Dashboards

The query is used in the dashboards: