activity_dashboard_events_by_actionactivity_dashboard_events_by_actoractivity_dashboard_events_by_orgactivity_dashboard_events_by_repositoryactivity_dashboard_events_by_source_ipactivity_dashboard_secret_scanning_alertsactivity_dashboard_total_eventsbranch_protection_disabledbranch_protection_policy_overriddenorganization_application_installedorganization_application_uninstalledorganization_ip_allow_list_entry_updatedorganization_moderator_addedorganization_moderator_removedorganization_ownership_transferredorganization_two_factor_authentication_disabledorganization_user_addedorganization_user_granted_owner_roleorganization_user_removedpersonal_access_token_grantedrepository_archivedrepository_member_updatedrepository_visibility_set_publicrepository_vulnerability_alert_dismissed
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_logwhere action = 'secret_scanning_alert.create'group by repoorder by count(*) desclimit 10;
Dashboards
The query is used in the dashboards: