turbot/aws_compliance

Query: route53_domain_expires_30_days

Usage

powerpipe query aws_compliance.query.route53_domain_expires_30_days

Steampipe Tables

SQL

select
arn as resource,
case
when date(expiration_date) - date(current_date) >= 30 then 'ok'
else 'alarm'
end as status,
title || ' set to expire in ' || extract(
day
from
expiration_date - current_date
) || ' days.' as reason,
region,
account_id
from
aws_route53_domain;

Controls

The query is being used by the following controls: