My DNS domain is 'localdomain', because it's defined as such on pfsense and in the hosts file of the raspberry pi
127.0.1.1 raspberrypi.localdomain raspberrypi
result on the pi:
pi@raspberrypi:~ $ dnsdomainname localdomain
result on a workstation (ipconfig /all):
Ethernet adapter Ethernet: Connection-specific DNS Suffix . : localdomain
My hosts file (NOT using custom.list, because it doesn't allow multiple name entries on one line) looks like this (partial):
192.168.2.166 slate7-2.localdomain slate7-2 192.168.2.227 hp7900.localdomain hp7900 192.168.2.228 y50.localdomain y50
Web interface, 'Long term data', 'query log'
Enter 'localdomain' in the search field, select 'today' as 'date and time range'
Apparently, don't really know if this is a v5 specific problem (may occur in v4), the result of the query shows all entries that match the search string 'localdomain' in both the domain and the client column. It is possible to find the entries that match 'localdomain' in the domain column, however, it's showing a lot of entries that only match the client name.
An SQL query would indicate the desired result would only list 29 entries, as opposed to the approximately 1250 (125 pages, 10 entries per page) entries listed in the web interface.
I don't know if the result the web interface shows, intentionally (developers choice?) includes the search string (localdomain) and matches it to both the domain and the client column. The result in the web interface however, doesn't really provide useful information.