default_branch_protection_disabled_unverifiable_countdefault_branch_protection_enabled_countdefault_branch_protection_tableopen_issue_1_year_countopen_issue_24_hours_countopen_issue_30_90_days_countopen_issue_30_days_countopen_issue_90_365_days_countopen_issue_countopen_issue_tableopen_pull_request_1_year_countopen_pull_request_24_hours_countopen_pull_request_30_90_days_countopen_pull_request_30_days_countopen_pull_request_90_365_days_countopen_pull_request_countopen_pull_request_tableorganization_2fa_disabled_countorganization_2fa_enabled_countorganization_2fa_tableorganization_2fa_unknown_countorganization_countorganization_member_privileges_tableorganization_paid_plan_seat_unused_countorganization_plan_seat_tableorganization_security_advisory_countorganization_security_advisory_critical_countorganization_security_advisory_high_countorganization_security_advisory_low_countorganization_security_advisory_medium_countorganization_security_advisory_tablerepository_101_500_stars_countrepository_1_100_stars_countrepository_501_1000_stars_countrepository_countrepository_license_tablerepository_other_license_countrepository_over_1000_stars_countrepository_permissive_license_countrepository_popular_copyleft_license_countrepository_private_countrepository_public_countrepository_security_advisory_countrepository_security_advisory_critical_countrepository_security_advisory_high_countrepository_security_advisory_low_countrepository_security_advisory_medium_countrepository_security_advisory_tablerepository_stargazer_tablerepository_unstarred_countrepository_visibility_tablerepository_weak_copyleft_license_countrepository_without_license_count
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 typefrom github_my_organizationwhere plan_name <> 'free';
Dashboards
The query is used in the dashboards: