turbot/github_sherlock

Control: License should be added in each public repository

Description

Licensing a public repository makes it easier for others to use and contribute.

Usage

steampipe check github_sherlock.control.public_repo_license_added

Plugins & Tables

SQL

select
html_url as resource,
case
when license_spdx_id is not null then 'ok'
else 'alarm'
end as status,
full_name || ' license is ' || case when(license_spdx_id is not null) then license_name else 'not added' end || '.' as reason,
full_name
from
github_my_repository
where
visibility = 'public' and fork = false