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_table

Usage

steampipe query github_insights.query.organization_security_advisory_table

SQL

select
o.login as "Organization",
a.security_advisory_summary as "Advisory",
a.security_advisory_severity as "Severity",
a.security_advisory_cve_id as "CVE",
a.dependency_package_name as "Package",
a.dependency_scope as "Scope",
a.created_at as "Alert Created",
now() :: date - a.created_at :: date as "Age in Days",
a.html_url as "advisory_url",
o.url,
case
when a.security_advisory_severity = 'critical' then 1
when a.security_advisory_severity = 'high' then 2
when a.security_advisory_severity = 'medium' then 3
when a.security_advisory_severity = 'low' then 4
else 5
end as weight
from
github_my_organization o
join github_organization_dependabot_alert a on o.login = a.organization
where
a.state = 'open'
order by
weight;

Dashboards

The query is used in the dashboards: