Control: Issues should have at least 1 user assigned

powerpipe control run github_sherlock.control.issue_has_assignee

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

select
  i.url as resource,
  case
    when assignees_total_count = 0 then 'alarm'
    when assignees_total_count = 1 then 'ok'
    -- More than 1 assignee could be ok, but let users know there's more than 1
    else 'info'
  end as status,
  '#' || i.number || ' ' || i.title || ' has ' || assignees_total_count || ' assignee(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'