Control: Issues should not be open longer than 30 days

powerpipe control run github_sherlock.control.issue_older_30_days

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

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'