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

Description

AWS IAM users can access AWS resources using console access. It is recommended that console access 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 console access unused for 45 days or greater are disabled

SQL