turbot/github_compliance
GitHub

Query: org_domain_verified

Usage

steampipe query github_compliance.query.org_domain_verified

Plugins & Tables

SQL

select
-- Required Columns
url as resource,
case
when is_verified then 'ok'
else 'alarm'
end as status,
coalesce(name, login) || ' domain is ' || case
when (is_verified) :: bool then 'verified'
else 'not verified'
end || '.' as reason,
-- Additional Dimensions
login
from
github_my_organization;

Controls

The query is being used by the following controls: