# Option to remove entries from new Network tab

**URL:** <https://discourse.pi-hole.net/t/option-to-remove-entries-from-new-network-tab/20273>\
**Category:** Implemented\
**Created:** [May 30, 2019, 9:26pm UTC](https://discourse.pi-hole.net/t/option-to-remove-entries-from-new-network-tab/20273 "2019-05-30T21:26:58Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![deHakkelaar](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/dehakkelaar/32/674_2.png) [@deHakkelaar](https://discourse.pi-hole.net/u/deHakkelaar)\
**Post date:** [June 1, 2019, 8:00pm UTC](https://discourse.pi-hole.net/t/option-to-remove-entries-from-new-network-tab/20273/10 "2019-06-01T20:00:02Z")

</div>

> [@Mcat12](#):
>
> Run `pihole -d` for a debug token.

Was just about to post below 😉

> [@zapfchance](#):
>
> If I empty the table completely, it just stays empty regardless of what activity is showing in the query log.

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`

---

_[View the full topic](https://discourse.pi-hole.net/t/option-to-remove-entries-from-new-network-tab/20273)._