turbot/github_insights

Query: repository_security_advisory_low_count

Usage

powerpipe query github_insights.query.repository_security_advisory_low_count

SQL

select
'Low' as label,
count(*) as value
from
github_my_repository r
join github_repository_dependabot_alert a on r.name_with_owner = a.repository_full_name
where
a.state = 'open'
and a.security_advisory_severity = 'low';

Dashboards

The query is used in the dashboards: