turbot/aws_compliance

Query: secretsmanager_secret_last_used_1_day

Usage

powerpipe query aws_compliance.query.secretsmanager_secret_last_used_1_day

SQL

select
arn as resource,
case
when date(last_accessed_date) - date(created_date) >= 1 then 'ok'
else 'alarm'
end as status,
case
when date(last_accessed_date)- date(created_date) >= 1 then title || ' recently used.'
else title || ' not used recently.'
end as reason
, region, account_id
from
aws_secretsmanager_secret;

Controls

The query is being used by the following controls: