Query: IAM users with console access should have MFA enabled

Description

Manage access to resources in the AWS Cloud by ensuring that MFA is enabled for all AWS Identity and Access Management (IAM) users that have a console password.

Query

Tables used in this query:

• aws_iam_credential_report

Controls using this query:

• 1.10 Ensure multi-factor authentication (MFA) is enabled for all IAM users that have a console password
• 1.10 Ensure multi-factor authentication (MFA) is enabled for all IAM users that have a console password
• 1.10 Ensure multi-factor authentication (MFA) is enabled for all IAM users that have a console password
• 1.10 Ensure multi-factor authentication (MFA) is enabled for all IAM users that have a console password
• 1.10 Ensure multi-factor authentication (MFA) is enabled for all IAM users that have a console password
• 1.10 Ensure multi-factor authentication (MFA) is enabled for all IAM users that have a console password
• 1.2 Ensure multi-factor authentication (MFA) is enabled for all IAM users that have a console password
• 5 MFA should be enabled for all IAM users that have a console password
• IAM users with console access should have MFA enabled

SQL