Add MAC Address column on Query log

Help
1

Hello,
If possible, someone with knowledge could give us guidance on how to do something similar to the image below:

image
image1395×520 153 KB

  • Add the MAC Address column (No manufacturer, just MAC) to the query log (queries.php and db_queries.php).

Based on /var/log/pihole.log I managed to generate a log file pihole2.log with the MAC Address following these steps (command line - How to generate a new log file containing the MAC adress based on pihole.log which didn't contain it by default - Ask Ubuntu)

  • Would it be possible to create an additional column in the sqlite table with the MAC of the device in which it was represented by its IP at the time of the search? (No Pihole DHCP, it is sent by the router)
  • When checking the recent queries and long term queries, it would also print the column with the MAC address that performed the query.

pihole.log output: Mar 9 00:45:52 dnsmasq[412]: query[A] www.msftconnecttest.com from 192.168.10.1
pihole2.log output: Mar 9 00:45:52 dnsmasq[412]: query[A] www.msftconnecttest.com from 192.168.10.1 dc:2c:6e:0e:8b:e0

Thank you!

2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.