turbot/github_insights

Query: organization_paid_plan_seat_unused_count

Usage

powerpipe query github_insights.query.organization_paid_plan_seat_unused_count

Steampipe Tables

SQL

select
'Unused Plan Seats' as label,
sum(plan_seats) - sum(plan_filled_seats) as value,
case
when (sum(plan_seats) - sum(plan_filled_seats)) > 0 then 'alert'
else 'ok'
end as type
from
github_my_organization
where
plan_name <> 'free';

Dashboards

The query is used in the dashboards: