# Resolve client IP-Adresses for the Long Term Data section

**URL:** <https://discourse.pi-hole.net/t/resolve-client-ip-adresses-for-the-long-term-data-section/55655>\
**Category:** Implemented\
**Created:** [May 26, 2022, 5:52pm UTC](https://discourse.pi-hole.net/t/resolve-client-ip-adresses-for-the-long-term-data-section/55655 "2022-05-26T17:52:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![netred](https://discourse-cdn.pi-hole.net/letter_avatar_proxy/v4/letter/n/bb73d2/32.png) [@netred](https://discourse.pi-hole.net/u/netred)\
**Post date:** [May 26, 2022, 5:52pm UTC](https://discourse.pi-hole.net/t/resolve-client-ip-adresses-for-the-long-term-data-section/55655/1 "2022-05-26T17:52:44Z")

</div>

The "real time" query list shows resolved client names instead of ip adresses.  
The Long Term Data menu option does only show the ip adresses , both for the query log and the top lists.  
This is not consistent and i'd like to see the name of the client instead.

---

<div class="post-metadata">

**Author:** ![yubiuser](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/yubiuser/32/12100_2.png) [@yubiuser](https://discourse.pi-hole.net/u/yubiuser)\
**Post date:** [May 31, 2022, 5:30am UTC](https://discourse.pi-hole.net/t/resolve-client-ip-adresses-for-the-long-term-data-section/55655/2 "2022-05-31T05:30:00Z")

</div>

> <https://github.com/pi-hole/FTL/pull/1285>
>
> \*\*By submitting this pull request, I confirm the following:\*\*
> 
> \- \[X\] I have re…ad and understood the \[contributors guide\](https://github.com/pi-hole/pi-hole/blob/master/CONTRIBUTING.md).
> \- \[X\] I have checked that \[another pull request\](https://github.com/pi-hole/FTL/pulls) for this purpose does not exist.
> \- \[X\] I have considered, and confirmed that this submission will be valuable to others.
> \- \[X\] I accept that this submission may not be used, and the pull request closed at the will of the maintainer.
> \- \[X\] I give this submission freely, and claim no ownership to its content.
> 
> \*\*How familiar are you with the codebase?:\*\* 
> 
> \## 10
> 
> \---
> 
> When restarting FTL, it imports history from the database to repopulate the history. So far, this was only possible with a reduced set of variables to keep the database from growing forever. Recent database optimizations https://github.com/pi-hole/FTL/pull/1255 reduced the database size significantly allowing us to store more data in the database.
> 
> This PR adds storing all the details necessary for the query log so a restart goes (almost) invisible and without any data loss.
> 
> \*) almost because some queries may not have been completed due to the forced restart and according service interruption.

[https://github.com/pi-hole/AdminLTE/pull/2202](https://github.com/pi-hole/AdminLTE/pull/2202)

[https://github.com/pi-hole/AdminLTE/pull/2245](https://github.com/pi-hole/AdminLTE/pull/2245)

---

<div class="post-metadata">

**Author:** ![yubiuser](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/yubiuser/32/12100_2.png) [@yubiuser](https://discourse.pi-hole.net/u/yubiuser)\
**Post date:** [July 8, 2022, 9:33pm UTC](https://discourse.pi-hole.net/t/resolve-client-ip-adresses-for-the-long-term-data-section/55655/3 "2022-07-08T21:33:13Z")

</div>

Released with [Pi-hole FTL v5.16, Web v5.13 and Core v5.11.1 released](https://discourse.pi-hole.net/t/pi-hole-ftl-v5-16-web-v5-13-and-core-v5-11-1-released/56384)

---

<div class="post-metadata">

**Author:** ![yubiuser](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/yubiuser/32/12100_2.png) [@yubiuser](https://discourse.pi-hole.net/u/yubiuser)\
**Post date:** [July 8, 2022, 9:33pm UTC](https://discourse.pi-hole.net/t/resolve-client-ip-adresses-for-the-long-term-data-section/55655/4 "2022-07-08T21:33:16Z")

</div>