activity_dashboard_client_error_countactivity_dashboard_redirect_countactivity_dashboard_requests_by_bucketactivity_dashboard_requests_by_dayactivity_dashboard_requests_by_erroractivity_dashboard_requests_by_operationactivity_dashboard_requests_by_requesteractivity_dashboard_requests_by_source_ipactivity_dashboard_requests_by_status_categoryactivity_dashboard_server_error_countactivity_dashboard_success_countactivity_dashboard_top_10_error_urisactivity_dashboard_top_10_keysactivity_dashboard_top_10_successful_urisactivity_dashboard_total_requestss3_bucket_accessed_using_insecure_tls_versions3_object_accessed_outside_business_hourss3_object_accessed_using_insecure_tls_versions3_object_accessed_using_suspicious_user_agents3_object_accessed_with_large_request_sizes3_object_accessed_with_large_response_size
Query: Top 10 Error Codes
Description
List the 10 most frequent error codes.
Usage
powerpipe query aws_s3_server_access_log_detections.query.activity_dashboard_requests_by_error
Tailpipe Tables
SQL
select error_code as "Error Code", count(*) as "Request Count"from aws_s3_server_access_logwhere error_code is not nullgroup by error_codeorder by count(*) desc, error_codelimit 10;
Dashboards
The query is used in the dashboards: