turbot/gitlab_insights

Query: project_access_request_table

Usage

powerpipe query gitlab_insights.query.project_access_request_table

SQL

select
p.full_path as "Project",
r.username as "User",
r.access_level_description as "Requested Access",
now()::date - r.requested_at::date as "Age in Days",
p.web_url
from
gitlab_my_project p
join gitlab_project_access_request r on p.id = r.project_id
where
r.state = 'active'
order by
"Age in Days" desc;

Dashboards

The query is used in the dashboards: