Query: identity_user_valid_email

select
  id as resource,
  case
    when email is null then 'alarm'
    when not email_verified then 'alarm'
    else 'ok'
  end as status,
  case
    when email is null then name || ' not associated with email address.'
    when not email_verified then name || ' associated with unverified email address.'
    else name || ' associated with valid email address.'
  end as reason
  
  , tenant_name as tenant
from
  oci_identity_user as a;