turbot/steampipe-mod-gitlab-insights

Dashboard: GitLab Project Access Request Report

This report answers the following questions:

  • Do any of my projects have open 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 Project Access Request Report dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run gitlab_insights.dashboard.project_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_my_project p
join gitlab_project_access_request r on p.id = r.project_id
where
r.state = 'active';

Tags