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

Control: Website URL should be set in each public repository

Description

Website URL should be set to provide the community awareness of where they can go for more information about the project.

Usage

Run the control in your terminal:

powerpipe control run github_sherlock.control.public_repo_website_set

Snapshot and share results via Turbot Pipes:

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

Steampipe Tables

github_my_repository
GitHub plugin

SQL

select
  url as resource,
  case
    when homepage_url <> '' then 'ok'
    else 'alarm'
  end as status,
  name_with_owner || ' homepage is ' || case
    when (homepage_url <> '') then homepage_url
    else 'not set'
  end || '.' as reason,
  name_with_owner
from
  github_my_repository
where
  visibility = 'PUBLIC'
  and is_fork = false

Tags

category = Compliance
plugin = github
service = GitHub/Repository