v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Plugins Docs Home

turbot/github_insights

0Controls

0Variables

default_branch_protection_disabled_unverifiable_count default_branch_protection_enabled_count default_branch_protection_table open_issue_1_year_count open_issue_24_hours_count open_issue_30_90_days_count open_issue_30_days_count open_issue_90_365_days_count open_issue_count open_issue_table open_pull_request_1_year_count open_pull_request_24_hours_count open_pull_request_30_90_days_count open_pull_request_30_days_count open_pull_request_90_365_days_count open_pull_request_count open_pull_request_table organization_2fa_disabled_count organization_2fa_enabled_count organization_2fa_table organization_2fa_unknown_count organization_count organization_member_privileges_table organization_paid_plan_seat_unused_count organization_plan_seat_table organization_security_advisory_count organization_security_advisory_critical_count organization_security_advisory_high_count organization_security_advisory_low_count organization_security_advisory_medium_count organization_security_advisory_table repository_101_500_stars_count repository_1_100_stars_count repository_501_1000_stars_count repository_count repository_license_table repository_other_license_count repository_over_1000_stars_count repository_permissive_license_count repository_popular_copyleft_license_count repository_private_count repository_public_count repository_security_advisory_count repository_security_advisory_critical_count repository_security_advisory_high_count repository_security_advisory_low_count repository_security_advisory_medium_count repository_security_advisory_table repository_stargazer_table repository_unstarred_count repository_visibility_table repository_weak_copyleft_license_count repository_without_license_count

Query: repository_unstarred_count

Usage

powerpipe query github_insights.query.repository_unstarred_count

Steampipe Tables

github_my_repository

GitHub plugin

SQL

select
  'Unstarred' as label,
  count(*) as value
from
  github_my_repository
where
  stargazer_count = 0;

Dashboards

The query is used in the dashboards:

GitHub Repository Stargazers Report