turbot/oci_insights

Query: identity_user_mfa_enabled

Usage

powerpipe query oci_insights.query.identity_user_mfa_enabled

Steampipe Tables

SQL

with mfa_stat as (
select
case
when is_mfa_activated then 'enabled'
else 'disabled'
end as mfa_stat
from
oci_identity_user
)
select
mfa_stat,
count(*)
from
mfa_stat
group by
mfa_stat

Dashboards

The query is used in the dashboards: