# List all active client mac addresses of all routers

**URL:** <https://forum.genieacs.com/t/list-all-active-client-mac-addresses-of-all-routers/4842>\
**Category:** Uncategorized\
**Created:** [December 10, 2023, 9:46am UTC](https://forum.genieacs.com/t/list-all-active-client-mac-addresses-of-all-routers/4842 "2023-12-10T09:46:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![sachin](https://avatars.discourse-cdn.com/v4/letter/s/c77e96/32.png) [@sachin](https://forum.genieacs.com/u/sachin)\
**Post date:** [December 10, 2023, 9:46am UTC](https://forum.genieacs.com/t/list-all-active-client-mac-addresses-of-all-routers/4842/1 "2023-12-10T09:46:47Z")

</div>

How can we implement a list of active client mac addresses of all routers in geneiacs with search filter? Is it possible with virtual parameters?

---

<div class="post-metadata">

**Author:** ![akcoder](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.genieacs.com/akcoder/32/11_2.png) [@akcoder](https://forum.genieacs.com/u/akcoder)\
**Post date:** [December 11, 2023, 5:48pm UTC](https://forum.genieacs.com/t/list-all-active-client-mac-addresses-of-all-routers/4842/2 "2023-12-11T17:48:21Z")

</div>

> [@sachin](#):
>
> How can we implement a list of active client mac addresses of all routers in geneiacs with search filter?

Are you trying to capture the mac address of every `Host` behind a CPE?

---

<div class="post-metadata">

**Author:** ![sachin](https://avatars.discourse-cdn.com/v4/letter/s/c77e96/32.png) [@sachin](https://forum.genieacs.com/u/sachin)\
**Post date:** [December 11, 2023, 6:04pm UTC](https://forum.genieacs.com/t/list-all-active-client-mac-addresses-of-all-routers/4842/3 "2023-12-11T18:04:17Z")

</div>

For a specific enterprise SSID , we are trying to get complete active client list in a table,with search filter so as to know which cpe has the following client connected.Can you please help?.

---

<div class="post-metadata">

**Author:** ![akcoder](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.genieacs.com/akcoder/32/11_2.png) [@akcoder](https://forum.genieacs.com/u/akcoder)\
**Post date:** [December 11, 2023, 6:07pm UTC](https://forum.genieacs.com/t/list-all-active-client-mac-addresses-of-all-routers/4842/4 "2023-12-11T18:07:03Z")

</div>

To my knowledge, this is not possible out of the box with GenieACS. You will either have to modify the code to add this functionality, or use another system to refresh the `AssociatedDevice` table via the NBI and capture and index those results.

---

<div class="post-metadata">

**Author:** ![sachin](https://avatars.discourse-cdn.com/v4/letter/s/c77e96/32.png) [@sachin](https://forum.genieacs.com/u/sachin)\
**Post date:** [December 12, 2023, 1:42pm UTC](https://forum.genieacs.com/t/list-all-active-client-mac-addresses-of-all-routers/4842/5 "2023-12-12T13:42:52Z")

</div>

Is it possible to fetch table details that contains username to mac address mappings which is MySQL db from a different server and write to a virtual parameter with proper refresh intervals?Requesting guidance.

---

<div class="post-metadata">

**Author:** ![akcoder](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.genieacs.com/akcoder/32/11_2.png) [@akcoder](https://forum.genieacs.com/u/akcoder)\
**Post date:** [December 12, 2023, 5:33pm UTC](https://forum.genieacs.com/t/list-all-active-client-mac-addresses-of-all-routers/4842/6 "2023-12-12T17:33:39Z")

</div>

With custom scripting, probably. But you will need to write all of that functionality yourself in your third-party system.