turbot/aws_insights

Query: iam_user_mfa_table

Usage

powerpipe query aws_insights.query.iam_user_mfa_table

Steampipe Tables

SQL

select
u.name as "User Name",
case
when u.mfa_enabled then 'Active'
else null
end as "MFA Status",
a.title as "Account",
a.account_id as "Account ID",
u.arn as "ARN"
from
aws_iam_user as u,
aws_account as a
where
u.account_id = a.account_id
order by
u.name;

Dashboards

The query is used in the dashboards: