Control: 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.
Usage
Run the control in your terminal:
powerpipe control run aws_compliance.control.iam_user_console_access_mfa_enabledSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_compliance.control.iam_user_console_access_mfa_enabled --shareSQL
This control uses a named query:
select  user_arn as resource,  case    when password_enabled and not mfa_active then 'alarm'    else 'ok'  end as status,  case    when not password_enabled then user_name || ' password login disabled.'    when password_enabled and not mfa_active then user_name || ' password login enabled but no MFA device configured.'    else user_name || ' password login enabled and MFA device configured.'  end as reason  , account_idfrom  aws_iam_credential_report;