Ignore a (sub)domain from showing in query logs

I know you can hide them like this: image
But is there a way to prevent them from being added in the database? Or like purge them automatically?

(and they still get added to the total amount of queries (what I don't want, I don't want them to show up anywhere, as they get sent ~ every second 24/7))

No this is not possible. You could only hide all domains or stopp logging to the database in general.

Similar feature request

I could stop pihole at night, then delete the queries from the database, and then start pihole again right?
(and would this remove the domain from everything, including long term data?)

#!/bin/bash
sudo service pihole-FTL stop &&
sudo sqlite3 /etc/pihole/pihole-FTL.db 'delete from queries where domain = "domain.com";' &&
sudo service pihole-FTL start

Logging means storing data for ex post analysis purposes.

By deleting data from logs for cosmetic reasons, you are going to reduce your future analysis capabilities.

Rather than wilfully ignoring what analysis results are already available, I would recommend to act on it.

Find the device that issues those requests and configure it to cease them.
If that's not possible, get rid of the device.
If you want to keep the device, consider configuring it to use a public DNS server so it won't spam your logs.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.