turbot/github_insights

Query: organization_security_advisory_critical_count

Usage

powerpipe query github_insights.query.organization_security_advisory_critical_count

SQL

select
'Critical' as label,
count(*) as value,
case
when count(*) > 0 then 'alert'
else 'ok'
end as type
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 = 'critical';

Dashboards

The query is used in the dashboards: