turbot/github_insights

Query: organization_security_advisory_count

Usage

powerpipe query github_insights.query.organization_security_advisory_count

SQL

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

Dashboards

The query is used in the dashboards: