Query: Secrets Manager secrets should be rotated as per the rotation schedule

Description

This rule ensures that AWS Secrets Manager secrets have rotated successfully according to the rotation schedule. Rotating secrets on a regular schedule can shorten the period that a secret is active, and potentially reduce the business impact if it is compromised.

Query

Tables used in this query:

• aws_secretsmanager_secret

Controls using this query:

• 2 Secrets Manager secrets configured with automatic rotation should rotate successfully
• Secrets Manager secrets should be rotated as per the rotation schedule

SQL