Control: Issues should not be open longer than 30 days
Description
Issues should be resolved or closed in a timely manner.
Usage
Run the control in your terminal:
powerpipe control run github_sherlock.control.issue_older_30_days
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run github_sherlock.control.issue_older_30_days --share
Steampipe Tables
SQL
select i.url as resource, case when i.created_at <= (current_date - interval '30' day) then 'alarm' else 'ok' end as status, '#' || i.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_namefrom github_my_repository as r left join github_issue as i on r.name_with_owner = i.repository_full_namewhere r.is_fork = false and i.state = 'OPEN'