turbot/aws_insights

Query: acm_certificate_by_transparency_logging_preference

Usage

powerpipe query aws_insights.query.acm_certificate_by_transparency_logging_preference

Steampipe Tables

SQL

select
certificate_transparency_logging_preference_status,
count(*)
from (
select certificate_transparency_logging_preference,
case when certificate_transparency_logging_preference = 'ENABLED' then
'enabled'
else
'disabled'
end certificate_transparency_logging_preference_status
from
aws_acm_certificate) as t
group by
certificate_transparency_logging_preference_status
order by
certificate_transparency_logging_preference_status desc;

Dashboards

The query is used in the dashboards: