Query: Secrets Manager secrets should be rotated within 365 days

Description

Ensure that AWS Secrets Manager secrets have been rotated in the past 365 days. The rule is non-compliant if a secret has not been rotated for more than 365 days. This control provides a more lenient rotation period compared to the 90-day requirement, which may be more suitable for some organizations.

Query

Tables used in this query:

• aws_secretsmanager_secret

Controls using this query:

• Secrets Manager secrets should be rotated within 365 days

SQL