turbot/gitlab_insights

Query: project_access_request_count

Usage

powerpipe query gitlab_insights.query.project_access_request_count

SQL

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';

Dashboards

The query is used in the dashboards: