Can I remove a specific domain from the logs?

[lefixi]

For example I want to remove google.com from the logs.
Is there a way to delete it from the database?
Also if I remove a device from the network table will it delete all it's logged domains?

[jfb]

@lefixi

For example I want to remove google.com from the logs.
Is there a way to delete it from the database?

Not via the Pi-hole web GUI. You can use SQL database commands to purge this from the database.

@lefixi

if I remove a device from the network table will it delete all it’s logged domains?

No.

[lefixi]

Hey, thanks for answering. I did delete them from the logs with
sqlite3 /etc/pihole/pihole-FTL.db "DELETE FROM queries WHERE domain='example.com';"

But I still have one more problem. It did not change the number of queries in the network tab. Is there a way to reflect the changes and get the new lower number after I deleted the queries?

[jfb]

I think you will need to delete the entire entry in the database for each of those queries. But, I have not done this so can only surmise.

Edit - this is incorrect. See further comments below.

[lefixi]

What do you mean 'entire entry'? Doesn't the SQL command I posted above do exactly that?

[DL6ER]

@lefixi

Doesn’t the SQL command I posted above do exactly that?

Yes, it is sufficient. @jfb SQLite3 always operates on whole database rows. DELETE FROM queries with WHERE domain='blah' will remove all entire lines under the given constraint.