# Adding alias-clients to Pi-hole FTL

**URL:** <https://discourse.pi-hole.net/t/adding-alias-clients-to-pi-hole-ftl/37084>\
**Category:** General\
**Created:** [August 11, 2020, 7:55pm UTC](https://discourse.pi-hole.net/t/adding-alias-clients-to-pi-hole-ftl/37084 "2020-08-11T19:55:12Z")\
**Posts on this page:** 1\
**Showing post:** 28

<div class="post-metadata">

**Author:** ![DL6ER](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/dl6er/32/281_2.png) [@DL6ER](https://discourse.pi-hole.net/u/DL6ER)\
**Post date:** [August 12, 2020, 6:06pm UTC](https://discourse.pi-hole.net/t/adding-alias-clients-to-pi-hole-ftl/37084/28 "2020-08-12T18:06:09Z")

</div>

Having seen @jpgpi250's interpretation of what this can be used for, I thought it may be a good idea to generalize the super-clients. So far, super-clients were set by using a MAC address as identifier. This is a limitation as you may have a device with:

- more than one MAC address (e.g., Ethernet and WiFi interface)
- devices without a MAC address being available (e.g., connected through VPN or on another VLAN)

So back to the drawing board!

Please first reset your database back to how it was before checking out the `new/super-clients` branch using:

```auto
sudo sqlite3 /etc/pihole/pihole-FTL.db "DROP TABLE superclient;"
sudo sqlite3 /etc/pihole/pihole-FTL.db "UPDATE ftl SET value = 8 WHERE id = 0;"

```

Then check out the latest version of this branch.

The `superclient` table now looks like this (`hwaddr` gone, `id` added):

| ID | host name | comment |
| --- | --- | --- |
| 0 | linux-box-1 | (optional) |

The `network` table - listing all _devices_ - gets an extra column at the end: `superclient_id` (referencing the `superclient` table's IDs)

You can add a super-client ID to as many MAC addresses (may be real or mock-MAC addresses) as you like. This will give you a lot more flexibility and should work equally well.

Example:

1. Check out the FTL branch

2. Add a new super-client

3. Assign two MAC addresses to this super-client (ID = 0)

4. Ask FTL to re-import super-clients

5. See that the said client is now inside the super-client `something`  

6. For the sake of demonstration, let's add the Top Client (25010 queries) to the same super-client:

7. Enjoy.  
All statistics from all addresses of these two devices are summarized under one name:

---

_[View the full topic](https://discourse.pi-hole.net/t/adding-alias-clients-to-pi-hole-ftl/37084)._