Cloudflare Logs

2025-12-172025-12-17

This document provides an overview of Cloudflare Logs, including their features, benefits, and how to access them.

LogExplorer screen have also custom dashboard

Logs Explorer/Log Search

Cloudflare Logs can be accessed through the Logs Explorer or Log Search feature in the Cloudflare dashboard. This allows users to query and analyze log data using a SQL based language.

Example SQL Query

• Search for all 403 responses from the host mno.us.unibeam.com:

SELECT 
    ClientRequestHost,
    ClientRequestMethod,
    ClientRequestURI,
    ClientRequestUserAgent,
    ClientIP,
    EdgeResponseStatus,
    EdgeStartTimestamp
FROM 
    http_requests 
WHERE 
    ClientRequestHost = 'mno.us.unibeam.com'
    AND EdgeResponseStatus = 403
ORDER BY 
    EdgeStartTimestamp DESC

• Search for all requests to the host api.us.unibeam.com:

SELECT 
    ClientRequestHost,
    ClientRequestMethod,
    ClientRequestURI,
    ClientRequestUserAgent,
    ClientIP,
    EdgeResponseStatus,
    EdgeStartTimestamp
FROM 
    http_requests 
WHERE 
    ClientRequestHost = 'api.us.unibeam.com'
ORDER BY 
    EdgeStartTimestamp DESC

• Search for all requests to the path /api/v1/business/transaction-touch on the host api.us.unibeam.com within a specific time range:

SELECT clientip, clientrequestmethod, clientrequesturi, edgeresponsestatus, originresponsestatus, clientrequestpath, clientdevicetype, clientrequestbytes, clientrequesthost, clientrequestprotocol, clientrequestsource, clientrequestscheme, clientrequestreferer FROM http_requests
   WHERE {{ timeFilter }}
 AND clientrequestpath = '/api/v1/business/transaction-touch' AND clientrequesthost = 'api.us.unibeam.com' LIMIT 500

• Search for all non-200 responses to the host api.us.unibeam.com within a specific time range on November 4, 2025:

SELECT 
    ClientRequestHost,
    ClientRequestMethod,
    ClientRequestURI,
    ClientRequestUserAgent,
    ClientIP,
    EdgeResponseStatus,
    EdgeStartTimestamp,
    EdgeResponseBodyBytes
FROM 
    http_requests 
WHERE date = '2025-11-04' 
 AND edgeendtimestamp <= '2025-11-04T07:21:35Z' 
 AND edgeendtimestamp >= '2025-11-04T01:21:35Z' 
 AND 
    ClientRequestHost = 'api.us.unibeam.com'
 AND EdgeResponseStatus != 200
ORDER BY 
    EdgeStartTimestamp DESC