turbot/gitlab_insights

Query: project_expiring_member_table

Usage

powerpipe query gitlab_insights.query.project_expiring_member_table

SQL

select
p.full_path as "Project",
m.username as "Member",
m.access_desc as "Access Level",
m.expires_at::date - now()::date as "Expires in Days",
p.web_url,
m.web_url as member_url
from
gitlab_my_project p
join gitlab_project_member m on p.id = m.project_id
where
m.state = 'active'
and m.expires_at is not null
order by
"Expires in Days";

Dashboards

The query is used in the dashboards: