turbot/oci_insights

Query: identity_user_by_verified_email

Usage

powerpipe query oci_insights.query.identity_user_by_verified_email

Steampipe Tables

SQL

with email_stat as (
select
case
when email_verified then 'verified' else 'unverified'
end as email_stat
from
oci_identity_user
)
select
email_stat,
count(*)
from
email_stat
group by
email_stat

Dashboards

The query is used in the dashboards: