Unique domain names per interval in the long-term database

Feature Requests
1

It would be amazing to add a screen or report type in the long-term data screen to show a deduped list of domain names visited in a given interval (day, week, etc.).
This will make log analysis so much easier.

First look up deduped names, then, if something interesting is seen, dig into that specific domain.

Currently, one could do this via SSH with:

holed -

cat pihole.log | awk '($8=="0.0.0.0") {print}' | awk '!blocked[$6]++ {print $6}'

allowed -

cat pihole.log | awk '($8!="0.0.0.0" && $7=="is") {print}' | grep 'Jan 19' | awk '!allow[$6]++ {print $6}'

2

Could you please add "in the long-term database" to the titel?
This would make it easier for others to see the difference between your FR and this one:

3

Both commands do not seem to work on the recent version of pihole (Core v6.3FTL v6.4.1Web interface v6.4)

OS: Raspbian GNU/Linux 12 (bookworm) aarch64

Host: Raspberry Pi 4 Model B Rev 1.4

Kernel: 6.12.47+rpt-rpi-v8

Trying “sudo cat /var/log/pihole/pihole.log | awk '($8=="0.0.0.0") {print}' | awk '!blocked[$6]++ {print $6}' “ yielded no results.

Excuse if these are NOOB questions…. Still learning… TIA.