turbot/github_insights

Query: repository_security_advisory_count

Usage

powerpipe query github_insights.query.repository_security_advisory_count

SQL

select
'Open Advisories' 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';

Dashboards

The query is used in the dashboards: