turbot/github_insights

Query: organization_security_advisory_low_count

Usage

powerpipe query github_insights.query.organization_security_advisory_low_count

SQL

select
'Low' as label,
count(*) as value
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 = 'low';

Dashboards

The query is used in the dashboards: