Query: Ensure IAM users with access keys unused for 45 days or greater are disabled

Description

AWS IAM users can access AWS resources using access keys. It is recommended that access keys 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:

• Ensure IAM users with access keys unused for 45 days or greater are disabled

SQL