turbot/tailpipe-mod-aws-s3-server-access-log-detections

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

SQL

select
error_code as "Error Code",
count(*) as "Request Count"
from
aws_s3_server_access_log
where
error_code is not null
group by
error_code
order by
count(*) desc,
error_code
limit 10;

Dashboards

The query is used in the dashboards: