Query: Ensure credentials unused for 45 days or greater are disabled

Description

AWS IAM users can access AWS resources using different types of credentials, such as passwords or access keys. It is recommended that all credentials that have been unused in 45 or greater days be deactivated or removed.

Query

Tables used in this query:

• aws_iam_credential_report

Controls using this query:

• 1.11 Ensure credentials unused for 45 days or more are disabled
• 1.12 Ensure credentials unused for 45 days or greater are disabled
• 1.12 Ensure credentials unused for 45 days or greater are disabled
• 1.12 Ensure credentials unused for 45 days or greater are disabled
• 1.12 Ensure credentials unused for 45 days or greater are disabled
• 1.12 Ensure credentials unused for 45 days or more are disabled
• 2.11 Ensure credentials unused for 45 days or more are disabled
• Ensure credentials unused for 45 days or greater are disabled

SQL