turbot/tailpipe-mod-apache-access-log-detections

Query: Top 10 URLs (Requests)

Description

List the top 10 requested URLs by request count.

Usage

powerpipe query apache_access_log_detections.query.activity_dashboard_top_10_urls

Tailpipe Tables

SQL

select
request_uri as "URL",
count(*) as "Request Count"
from
apache_access_log
where
request_uri is not null
group by
request_uri
order by
count(*) desc,
request_uri
limit
10;

Dashboards

The query is used in the dashboards: