Long Term Query Log -> Excel Pivot Chart

sqlite3 /etc/pihole/pihole-FTL.db -header -csv "Select * from queries where timestamp > strftime('%s','now','-30 days');" > ./export.csv

2 Likes