turbot/alicloud_insights

Query: ram_credential_entities_console_access_with_no_mfa_count

Usage

powerpipe query alicloud_insights.query.ram_credential_entities_console_access_with_no_mfa_count

SQL

select
count(*) as value,
'Console Access and No MFA' as label,
case when count(*) = 0 then 'ok' else 'alert' end as type
from
alicloud_ram_credential_report
where
password_active
and not mfa_active;