Skip to content

Add non categorized reporting #2425

@ra-at-diladele-com

Description

@ra-at-diladele-com
SELECT 
    domain, count(domain) as hits 
FROM records 
    WHERE (
        session != 0 AND categories == 0 AND user_id NOT IN ('127.0.0.1', '-') AND verdict != 'bypass' AND response_code == 200 AND request_method == 'CONNECT'
    )
    GROUP BY domain
HAVING hits > 50
    ORDER BY hits
DESC
LIMIT 1000 

Metadata

Metadata

Labels

No labels
No labels

Type

No type
No fields configured for issues without a type.

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions