Not showing hostnames from 04-pihole-static-dhcp.conf file

[deHakkelaar]

Below for the ARP cache network database table (includes a backup):

Option to remove entries from new Network tab

Was just about to post below Try fresh with the tools that are already available and known to work. First create backup: cd ~ sqlite3 /etc/pihole/pihole-FTL.db ".backup main pihole-FTL.db.bak" See what columns have been created in the network table (id, ip, hwaddr, interface etc): sqlite3 /etc/pihole/pihole-FTL.db ".schema network" See what entries are in the network table now: sqlite3 /etc/pihole/pihole-FTL.db "SELECT * FROM network" Or: sqlite3 /etc/pihole/pihole-FTL.db ".du…

Below for the queries database table but replace step one with below one:

sudo -u pihole sqlite3 /etc/pihole/pihole-FTL.db

Deleting a client from the database

This post contains scripts, or links to scripts, that are untested by the Pi-hole team. We encourage users to be creative, but we are unable to support any potential problems caused by running these scripts Have you ever wondered how to delete a client from Pi-hole? Just follow these simple steps: FOR EXPERTS sqlite3 /etc/pihole/pihole-FTL.db sqlite> DELETE from queries WHERE client = 'clientIP'; Verify that you deleted the client sqlite> SELECT * FROM queries WHERE client = 'clientIP'; …