turbot/steampipe-mod-gitlab-insights

Dashboard: GitLab Group Access Request Report

This report answers the following questions:

  • Do any of my groups have open access requests?
  • How old are my group access requests?
This dashboard contains 2 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 Group Access Request Report dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:
select
'Active Requests' as label,
count(r.*) as value,
case
when count(r.*) > 0 then 'alert'
else 'ok'
end as type
from
gitlab_group g
join gitlab_group_access_request r on g.id = r.group_id
where
r.state = 'active';

Tags