Steampipe mods are now Powerpipe →
Powerpipe Hub 
Hub
Mods
turbot/github_sherlock
Overview
4Dashboards
34Controls
0Queries
0Variables
GitHub
Loading controls...

Control: Organization email should be set

Description

Setting an email provides useful contact information for users.

Usage

Run the control in your terminal:

powerpipe control run github_sherlock.control.org_email_set

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run github_sherlock.control.org_email_set --share

Steampipe Tables

github_my_organization
GitHub plugin

SQL

select
  url as resource,
  case
    when email is null then 'alarm'
    when email = '' then 'alarm'
    else 'ok'
  end as status,
  coalesce(name, login) || ' email is ' || case
    when (email is null) then 'not set'
    when (email = '') then 'not set'
    else email
  end || '.' as reason,
  login
from
  github_my_organization

Tags

category = Compliance
plugin = github
service = GitHub/Organization