# How to make Pi-hole pick a specific host name?

**URL:** <https://discourse.pi-hole.net/t/how-to-make-pi-hole-pick-a-specific-host-name/23505>\
**Category:** Help\
**Created:** [September 12, 2019, 8:40pm UTC](https://discourse.pi-hole.net/t/how-to-make-pi-hole-pick-a-specific-host-name/23505 "2019-09-12T20:40:28Z")\
**Posts on this page:** 1\
**Showing post:** 17

<div class="post-metadata">

**Author:** ![mikeyw64](https://discourse-cdn.pi-hole.net/letter_avatar_proxy/v4/letter/m/c4cdca/32.png) [@mikeyw64](https://discourse.pi-hole.net/u/mikeyw64)\
**Post date:** [September 27, 2019, 3:20pm UTC](https://discourse.pi-hole.net/t/how-to-make-pi-hole-pick-a-specific-host-name/23505/17 "2019-09-27T15:20:46Z")

</div>

in which case it might be better doing custom queries direct on the DB as outlined here

> [@Exporting PiHole Stats for use in Excel](https://discourse.pi-hole.net/t/exporting-pihole-stats-for-use-in-excel/23726):
>
> This is the way I do it. The example below exports the date timestamp in human readable format, the domain that was looked up and the [status code](https://docs.pi-hole.net/ftldns/database/#supported-status-types) for all queries from a specific client . I am then running samba so I can retrieve the file from my laptop and open in excel so I can run it through a pivot table. Obviously this can be expanded upon as required pi@Heimdall:~ $ sqlite3 "/etc/pihole/pihole-FTL.db" SQLite version 3.27.2 2019-02-25 16:06:06 Enter ".help" for usage hints. sqlite\> .head…

---

_[View the full topic](https://discourse.pi-hole.net/t/how-to-make-pi-hole-pick-a-specific-host-name/23505)._