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

Query: Top 10 Requesters

Description

List the top 10 requesters by frequency.

Usage

powerpipe query aws_s3_server_access_log_detections.query.activity_dashboard_requests_by_requester

SQL

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

Dashboards

The query is used in the dashboards: