Option to remove entries from new Network tab

Feature Requests Implemented
10

Was just about to post below :wink:

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 ".dump network"

Delete the unwanted entries based on the "id", the first column in the network table (replace the 9999 id number):

sudo -u pihole sqlite3 /etc/pihole/pihole-FTL.db "DELETE FROM network WHERE id = 9999"

And check if its deleted now:

sqlite3 /etc/pihole/pihole-FTL.db "SELECT * FROM network"

To rollback and restore the backup in case things go wrong:

sudo service pihole-FTL stop

sudo -u pihole sqlite3 /etc/pihole/pihole-FTL.db ".restore main pihole-FTL.db.bak"

sudo service pihole-FTL start

2 Likes