turbot/github_insights

Query: organization_plan_seat_table

Usage

powerpipe query github_insights.query.organization_plan_seat_table

Steampipe Tables

SQL

select
login as "Organization",
plan_name as "Plan Name",
case
when plan_name = 'free' then 'n/a'
else plan_filled_seats :: text || ' / ' || plan_seats :: text
end as "Used Seats",
url
from
github_my_organization
order by
plan_name desc;

Dashboards

The query is used in the dashboards: