summaryrefslogtreecommitdiff
path: root/src/db_handler.py
diff options
context:
space:
mode:
Diffstat (limited to 'src/db_handler.py')
-rw-r--r--src/db_handler.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/db_handler.py b/src/db_handler.py
index 1c271d6..7ba74f8 100644
--- a/src/db_handler.py
+++ b/src/db_handler.py
@@ -64,7 +64,7 @@ SELECT count(la.id) as total_count, date_trunc('hour', la.timestamp) as date, cn
FROM login_attempt la
JOIN connection cn on cn.id = la.connection
GROUP BY date_trunc('hour', la.timestamp), cn.ip
-ORDER BY date_trunc('hour', la.timestamp) DESC;
+ORDER BY COUNT(la.id)
;
""")
histogram = cur.fetchall()