Control: Issues should have at least 1 user assigned
Issues should have at least 1 assignee so it's clear who is responsible for it.
Run the control in your terminal:
steampipe check github_sherlock.control.issue_has_assignee
Snapshot and share results via Steampipe Cloud:
steampipe loginsteampipe check --share github_sherlock.control.issue_has_assignee
Plugins & Tables
selecti.url as resource,casewhen 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 1else 'info'end as status,'#' || i.number || ' ' || i.title || ' has ' || assignees_total_count || ' assignee(s).' as reason,i.repository_full_namefromgithub_my_repository as rleft join github_issue as i on r.name_with_owner = i.repository_full_namewherer.is_fork = falseand i.state = 'OPEN'