Control: Code of conduct should be added in each public repository

Usage

Run the control in your terminal:

steampipe check github_sherlock.control.public_repo_code_of_conduct_added

Snapshot and share results via Steampipe Cloud:

steampipe login
steampipe check --share github_sherlock.control.public_repo_code_of_conduct_added

github_my_repository

SQL

select
  url as resource,
  case
    when code_of_conduct is not null then 'ok'
    else 'alarm'
  end as status,
  name_with_owner || ' code of conduct is ' || case
    when (code_of_conduct is not null) then (code_of_conduct ->> 'name')
    else 'not added'
  end || '.' as reason,
  name_with_owner
from
  github_my_repository
where
  visibility = 'PUBLIC'
  and is_fork = false

Tags