Control: Issues should have labels applied

Usage

Run the control in your terminal:

steampipe check github_sherlock.control.issue_has_labels

Snapshot and share results via Steampipe Cloud:

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

github_issue

github_my_repository

SQL

select
  i.url as resource,
  case
    when i.labels_total_count > 0 then 'ok'
    else 'alarm'
  end as status,
  '#' || i.number || ' ' || i.title || ' has ' || i.labels_total_count || ' label(s).' as reason,
  i.repository_full_name
from
  github_my_repository as r
  left join github_issue as i on r.name_with_owner = i.repository_full_name
where
  r.is_fork = false
  and i.state = 'OPEN'

Tags