View Issue Details

IDProjectCategoryView StatusLast Update
0002191VPOP3Adminpublic2021-03-19 15:52
ReporterpaulAssigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status newResolutionopen 
Product Version 
Target VersionFixed in Version 
Summary0002191: Some manual DB queries don't work from settings
DescriptionDB query doesn't work in settings

Shows as 'undefined' in the results:

with x as (select ipaddress, username, count(*) cnt, min(datetime) as datetime from loginaudit where not result and datetime>now()-interval '1 day' group by ipaddress,username) select count(*) usercount, sum(cnt) failcount, ipaddress, min(datetime) as datetime from x where ipaddress not in (select ipaddress from abuseipdb) group by ipaddress having count(*)>=3 limit 10;

(needs AbuseIPDB table set up as in blog for this particular query)
TagsNo tags attached.
Support Ticket Number
Time Estimate


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2021-03-19 15:52 paul New Issue