turbot/gitlab_insights

Query: branch_protection_table

Usage

powerpipe query gitlab_insights.query.branch_protection_table

SQL

select
p.full_path as "Project",
b.name as "Branch",
b.protected as "Is Protected",
b.devs_can_push as "Developer Can Push",
b.devs_can_merge as "Developer Can Merge",
b.can_push as "You Can Push",
b.web_url,
p.web_url as project_url
from
gitlab_my_project p
join gitlab_branch b on p.id = b.project_id;

Dashboards

The query is used in the dashboards: