Query: ram_user_mfa_table

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;