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 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_logwhere additional_fields ->> 'repo' is not nullgroup by additional_fields ->> 'repo'order by count(*) desclimit 10;
Dashboards
The query is used in the dashboards: