Query: IAM root user hardware MFA should be enabled

Description

Manage access to resources in the AWS Cloud by ensuring hardware MFA is enabled for the root user.

Query

Tables used in this query:

• aws_iam_account_summary
• aws_iam_virtual_mfa_device

Controls using this query:

• 1.14 Ensure hardware MFA is enabled for the "root" account
• 1.6 Ensure hardware MFA is enabled for the 'root' user account
• 1.6 Ensure hardware MFA is enabled for the 'root' user account
• 1.6 Ensure hardware MFA is enabled for the 'root' user account
• 1.6 Ensure hardware MFA is enabled for the 'root' user account
• 1.6 Ensure hardware MFA is enabled for the 'root' user account
• 1.6 Ensure hardware MFA is enabled for the "root user" account
• 6 Hardware MFA should be enabled for the root user
• IAM root user hardware MFA should be enabled

SQL