turbot/steampipe-mod-gitlab-insights

Dashboard: GitLab Branch Activity Report

This report answers the following questions:

  • How old are my branches?
  • Are there any stale branches I should consider for cleaning?
This dashboard contains 6 cards and 1 table.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-gitlab-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select GitLab Branch Activity Report dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run gitlab_insights.dashboard.branch_activity_report --share

Queries

This dashboard uses the the following queries:
select
'> 1 Year' as label,
count(b.*) as value
from
gitlab_branch b
where
b.project_id in (
select
id
from
gitlab_my_project
)
and b.commit_date <= now() - '1 year' :: interval;

Tags