dozzle SQL Example

gistfile1.txt

-- list all docker log entries with particular status code
SELECT
    STRFTIME(TO_TIMESTAMP(ts )::TIMESTAMP,'%Y-%m-%d %H:%M:%S') AS datetime,
    request.headers."X-Real-Ip" as source,
    request.method,
    status,
    request.host as target,
    request.uri,
    request.headers."User-Agent" as userAgent
FROM logs
WHERE logger = 'http.log.access'
  AND request.uri != '/api/_info/health-check'
  AND status >= 200
;