Query: Secrets Manager secrets should have automatic rotation enabled

Description

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

Query

Tables used in this query:

• aws_secretsmanager_secret

Controls using this query:

• 1 Secrets Manager secrets should have automatic rotation enabled
• Secrets Manager secrets should have automatic rotation enabled

SQL