GitHub Default Branch Protection ReportGitHub Open Issue Age ReportGitHub Open Pull Request Age ReportGitHub Organization 2FA ReportGitHub Organization Member Privileges ReportGitHub Organization Plan Seat ReportGitHub Organization Security Advisory ReportGitHub Repository License ReportGitHub Repository Security Advisory ReportGitHub Repository Stargazers ReportGitHub Repository Visibility Report
Dashboard: GitHub Open Issue Age Report
This report answers the following questions:
- How old are open issues on specified repositories?
- When were open issues last updated on specified repositories?
This dashboard contains 6 cards and 1 table.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-github-insightsStart the Powerpipe server:
steampipe service startpowerpipe serverOpen http://localhost:9033 in your browser and select GitHub Open Issue Age Report dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run github_insights.dashboard.issue_open_age_report --shareQueries
This dashboard uses the the following queries:
select '> 1 Year' as label, count(i.*) as valuefrom github_my_repository r join github_issue i on i.repository_full_name = r.name_with_ownerwhere i.state = 'OPEN' and i.created_at <= now() - '1 year' :: interval;