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

Query: Top 10 Actors (Excluding Bots)

Description

List the top 10 actors by frequency, excluding bot accounts.

Usage

powerpipe query github_audit_log_detections.query.activity_dashboard_events_by_actor

Tailpipe Tables

SQL

select
actor as "Actor",
count(*) as "Events"
from
github_audit_log
where
actor is not null
and (additional_fields -> 'actor_is_bot') = false
group by
actor
order by
count(*) desc
limit 10;

Dashboards

The query is used in the dashboards: