turbot/alicloud_insights

Query: ram_user_mfa_table

Usage

powerpipe query alicloud_insights.query.ram_user_mfa_table

SQL

select
u.name as "User Name",
u.arn as "ARN",
mfa ->> 'SerialNumber' as "MFA Serial Number",
case when u.mfa_enabled then 'Active' else null end as "MFA Status",
mfa ->> 'ActivateDate' as "Activate Date",
a.title as "Account",
a.account_id as "Account ID"
from
alicloud_ram_user as u,
alicloud_account as a,
jsonb_array_elements(virtual_mfa_devices) as mfa
where
u.account_id = a.account_id
order by
u.mfa_enabled desc,
u.name;

Dashboards

The query is used in the dashboards: