Identify Expired Certificates

Queries & Insights
,
1

Expired SSL certificates can lead to service disruptions and security vulnerabilities. Here’s a PostgreSQL query that you can use to find all expired certificates from your AWS CloudQuery sync.

SELECT
    account_id,
    arn,
    domain_name,
    not_after,
    status
FROM
	aws_acm_certificates
WHERE status = 'EXPIRED' 
ORDER BY
	not_after ASC
1 Like