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: