How to Extract DNS Queries

[mikeyw64]

I've put together a basic method of querying the long term database that can be used as a starting point for constructing your own queries

Exporting PiHole Stats for use in Excel

This is the way I do it. The example below exports the date timestamp in human readable format, the domain that was looked up and the status code for all queries from a specific client . I am then running samba so I can retrieve the file from my laptop and open in excel so I can run it through a pivot table. Obviously this can be expanded upon as required pi@Heimdall:~ $ sqlite3 "/etc/pihole/pihole-FTL.db" SQLite version 3.27.2 2019-02-25 16:06:06 Enter ".help" for usage hints. sqlite> .head…