pi-hole:analytics
This is an old revision of the document!
Table of Contents
Pi-Hole - Analytics
Top Queried Domains
/etc/pihole/pihole-FTL.db "SELECT DOMAIN, count(DOMAIN) FROM queries WHERE (STATUS == 2 OR STATUS == 3) GROUP BY DOMAIN ORDER BY count(DOMAIN) DESC LIMIT 15"
returns:
Top Blocked Domains
/etc/pihole/pihole-FTL.db "SELECT DOMAIN, count(DOMAIN) FROM queries WHERE (STATUS == 1 OR STATUS == 4 OR STATUS == 5 OR STATUS == 6 OR STATUS == 7 OR STATUS = 8) GROUP BY DOMAIN ORDER BY count(DOMAIN) DESC LIMIT 15"
returns:
pi-hole/analytics.1613034947.txt.gz · Last modified: 2021/02/11 09:15 by peter