turbot/tailpipe-mod-github-audit-log-detections

Query: Top 10 Secret Scanning Alerts

Description

List the top 10 repositories with the most secret scanning alerts.

Usage

powerpipe query github_audit_log_detections.query.activity_dashboard_secret_scanning_alerts

Tailpipe Tables

SQL

select
repo as "Repository",
count(*) as "Alerts"
from
github_audit_log
where
action = 'secret_scanning_alert.create'
group by
repo
order by
count(*) desc
limit 10;

Dashboards

The query is used in the dashboards: