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

Query: Top 10 Repositories

Description

List the top 10 repositories by log count.

Usage

powerpipe query github_audit_log_detections.query.activity_dashboard_events_by_repository

Tailpipe Tables

SQL

select
additional_fields ->> 'repo' as "Repository",
count(*) as "Events"
from
github_audit_log
where
additional_fields ->> 'repo' is not null
group by
additional_fields ->> 'repo'
order by
count(*) desc
limit
10;

Dashboards

The query is used in the dashboards: