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

Query: Top 10 Operations

Description

List the top 10 S3 operations by frequency.

Usage

powerpipe query aws_s3_server_access_log_detections.query.activity_dashboard_requests_by_operation

SQL

select
operation as "Operation",
count(*) as "Request Count"
from
aws_s3_server_access_log
group by
operation
order by
count(*) desc,
operation
limit 10;

Dashboards

The query is used in the dashboards: