turbot/github_insights
GitHub
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_security_advisory_high_count

Usage

steampipe query github_insights.query.organization_security_advisory_high_count

SQL

select
'High' as label,
count(*) as value,
case
when count(*) > 0 then 'alert'
else 'ok'
end as type
from
github_my_organization o
join github_organization_dependabot_alert a on o.login = a.organization
where
a.state = 'open'
and a.security_advisory_severity = 'high';

Dashboards

The query is used in the dashboards: