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