GitLab Branch Activity ReportGitLab Branch Protection ReportGitLab Group 2FA ReportGitLab Group Access Request ReportGitLab Group Expiring Members ReportGitLab Group Visibility ReportGitLab My Open Issues Age ReportGitLab Open Epics Age ReportGitLab Open Issues Age ReportGitLab Open Merge Request Age ReportGitLab Project Access Request ReportGitLab Project Expiring Members ReportGitLab Project Failed Pipelines ReportGitLab Project License ReportGitLab Project Stars ReportGitLab Project Visibility Report
Dashboard: GitLab Open Merge Request Age Report
This report answers the following questions:
- How old are the open merge requests on my projects?
This dashboard contains 6 cards and 1 table.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-gitlab-insightsStart the Powerpipe server:
steampipe service startpowerpipe serverOpen http://localhost:9033 in your browser and select GitLab Open Merge Request Age Report dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run gitlab_insights.dashboard.merge_request_open_age_report --shareQueries
This dashboard uses the the following queries:
select '> 1 Year' as label, count(m.*) as valuefrom gitlab_my_project p join gitlab_merge_request m on m.project_id = p.idwhere m.state = 'opened' and m.created_at <= now() - '1 year' :: interval;