Query: identity_user_mfa_report

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;