How to make Pi-hole pick a specific host name?

[mikeyw64]

in which case it might be better doing custom queries direct on the DB as outlined here

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…