Query: Secrets Manager secrets should be rotated within specific number of days

Description

Ensure that AWS Secrets Manager secrets have been rotated in the past specified number of days. The rule is non-compliant if a secret has not been rotated for more than 'maxDaysSinceRotation' number of days. The default value is 90 days.

Query

Tables used in this query:

• aws_secretsmanager_secret

Controls using this query:

• Secrets Manager secrets should be rotated within specific number of days

SQL