turbot/github_sherlock
GitHub
Loading controls...

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:

steampipe check github_sherlock.control.issue_older_30_days

Snapshot and share results via Steampipe Cloud:

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

Plugins & 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_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