turbot/steampipe-mod-aws-insights

Dashboard: AWS ACM Certificate Detail

This dashboard answers the following questions for each certificate:

  • What relationships does the certificate have with other resources?
  • How is the certificate configured?
  • What tags are applied?
  • What is the algorithm of the certificate key?
  • Why was the certificate revoked?
  • How is the domain name in the certificate validated?
This dashboard contains 5 cards, 1 graph, 1 input and 6 tables.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-aws-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select AWS ACM Certificate Detail dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run aws_insights.dashboard.acm_certificate_detail --share

Queries

This dashboard uses the the following queries:
select
option ->> 'DomainName' as "Domain Name",
option ->> 'ResourceRecord' as "Resource Record",
option ->> 'ValidationDomain' as "Validation Domain",
option -> 'ValidationEmails' as "Validation Emails",
option ->> 'ValidationMethod' as "Validation Method",
option ->> 'ValidationStatus' as "Validation Status"
from
aws_acm_certificate as c,
jsonb_array_elements(domain_validation_options) as option
where
account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4)
and certificate_arn = $1;

Tags