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 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_logwhere actor is not null and (additional_fields -> 'actor_is_bot') = falsegroup by actororder by count(*) desclimit 10;
Dashboards
The query is used in the dashboards: