turbot/oci_compliance

Query: identity_user_valid_email

Usage

powerpipe query oci_compliance.query.identity_user_valid_email

Steampipe Tables

SQL

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;

Controls

The query is being used by the following controls: