turbot/alicloud_insights

Query: ram_user_mfa_devices

Usage

powerpipe query alicloud_insights.query.ram_user_mfa_devices

Steampipe Tables

SQL

select
mfa -> 'User' ->> 'UserId' as "User ID",
mfa ->> 'SerialNumber' as "MFA Serial Number",
mfa ->> 'ActivateDate' as "Activate Date"
from
alicloud_ram_user,
jsonb_array_elements(virtual_mfa_devices) as mfa
where
arn = $1
and account_id = split_part($1,':',4);

Dashboards

The query is used in the dashboards: