turbot/aws_insights

Query: sqs_queue_by_encryption_status

Usage

powerpipe query aws_insights.query.sqs_queue_by_encryption_status

Steampipe Tables

SQL

select
encryption_status,
count(*)
from
(
select
kms_master_key_id,
case
when kms_master_key_id is not null
or sqs_managed_sse_enabled then 'enabled'
else 'disabled'
end encryption_status
from
aws_sqs_queue
) as t
group by
encryption_status
order by
encryption_status desc;

Dashboards

The query is used in the dashboards: