turbot/ibm_compliance

Query: iam_user_mfa_enabled_all

Usage

powerpipe query ibm_compliance.query.iam_user_mfa_enabled_all

Steampipe Tables

SQL

select
account_id as resource,
case
when mfa = 'NONE' then 'alarm'
else 'ok'
end as status,
case
when mfa = 'NONE' then 'MFA not enabled for all users in account.'
else 'MFA enabled for all users in account.'
end as reason,
account_id
from
ibm_iam_account_settings;

Controls

The query is being used by the following controls: