Control: Issues should not be open longer than 30 days
Issues should be resolved or closed in a timely manner.
steampipe check github_sherlock.control.issue_older_30_days
Plugins & Tables
selecti.html_url as resource,casewhen i.created_at <= (current_date - interval '30' day) then 'alarm'else 'ok'end as status,'#' || i.issue_number || ' ' || i.title || ' created ' || to_char(i.created_at , 'DD-Mon-YYYY') ||' (' || extract(day from current_timestamp - i.created_at) || ' days).' as reason,i.repository_full_namefromgithub_my_repository as rleft join github_issue as i on r.full_name = i.repository_full_namewherer.fork = false and i.state = 'open'