turbot/oci_insights

Query: identity_user_mfa_report

Usage

powerpipe query oci_insights.query.identity_user_mfa_report

SQL

select
u.name as "User Name",
case
when u.is_mfa_activated then 'Enabled'
else null
end as "MFA Status",
t.name as "Tenancy",
u.id as "OCID"
from
oci_identity_user as u,
oci_identity_tenancy as t
where
t.id = u.tenant_id
order by
u.name;

Dashboards

The query is used in the dashboards: