turbot/gitlab_insights

Query: group_access_request_table

Usage

powerpipe query gitlab_insights.query.group_access_request_table

SQL

select
g.full_path as "Group",
r.username as "User",
r.access_level_description as "Requested Access",
now() :: date - r.requested_at :: date as "Age in Days",
g.web_url
from
gitlab_group g
join gitlab_group_access_request r on g.id = r.group_id
where
r.state = 'active';

Dashboards

The query is used in the dashboards: