Query: List secrets that automatically rotate every 7 days

Description

Identify the secrets in your AWS Secrets Manager that are set to automatically rotate more frequently than every 7 days. This can be useful for maintaining a high level of security by ensuring that secrets are updated regularly.

Query

Tables used in this query:

• aws_secretsmanager_secret

SQL