AdGuardHome icon indicating copy to clipboard operation
AdGuardHome copied to clipboard

Filter query log by date

Open ameshkov opened this issue 7 years ago • 19 comments

Source: https://github.com/AdguardTeam/AdGuardHome/issues/480

On the "Query Log" page, it would be great to be able to specify a time range, e.g. show only queries from 11:48:00 to 11:49:00 Also, when I want to see more rows of data and select "100 rows" on the bottom of the screen, it would be great if AdGuard would remember that choice.

ameshkov avatar Dec 17 '18 11:12 ameshkov

While we're at it, it would be superb to

  1. toggle live view while we're viewing the log.
  2. Add more options than 100 rows

tomiams avatar Dec 19 '18 06:12 tomiams

Tasks for query logs:

  • Apply sort and filter results for all components at once (may helps to avoid implement #946 #314)
    • Querylog, Dashboard
    • General statistics
    • Used filters stats #580
    • Per client stats #1336
  • Keep sort result till modify or clear it manually #845 #855
  • Ranges
    • Date range - day, week, month, custom #750 , https://github.com/AdguardTeam/AdGuardHome/issues/776#issuecomment-499468432
    • Time range - 5min, 10min, 1hr, custom
    • Clients range - IP, MAC, CIDR, nickname range #1273
  • Filter options #882 #594 (may helps to avoid implement #946 #1126)
  • Collapsed query log for time series data #1164

Screenshot_4 https://www.ntop.org/products/traffic-analysis/ntop (ntopng professional) https://github.com/ntop/ntopng, https://www.glasswire.com

( possible to avoid implement https://github.com/AdguardTeam/AdGuardHome/issues/767 )

ghost avatar Jul 27 '19 10:07 ghost

It's shame to AG that Pi-Hole has this feature😉 (today noticed that)

Screenshot_1

ghost avatar Oct 28 '19 01:10 ghost

More tasks for query logs:

  • The Previous and Next buttons on top (pt.4 from #1125)
  • Add a "Block client" button to the Query Log #1097
  • Query Log screen enhancement - Show name of Filters list #993
  • Responsive Design on Query Log page (smartphone) #978
  • change querylog.json location or add live view only (no write to disk) #876
  • Remember Row Count selection on Refresh #855
  • Query Log - Basic/Detailed View #697
  • Less Obtrusive Block/Unblock Button in Query Log #684
  • Domain filter in query log is case-sensitive #680
  • Query Log - Compact Mode #622
  • Add filter option to the filtering log #594
  • See used Upstream DNS server #468

szolin avatar Oct 31 '19 12:10 szolin

Other tasks for query logs:

  • Add response time to Query Log #1601
  • Allow searching in response field #1933 Possible to implement with: https://github.com/AdguardTeam/AdGuardHome/issues/594#issuecomment-469129412
  • Allow search IP in response field #1416 Related: https://github.com/AdguardTeam/AdGuardHome/issues/594#issuecomment-469129412
  • Filter in Query Log on Tag(s) #1583
  • See used Upstream DNS server #468 #1919
  • Request to add DNS query type value/filter #1900
  • Search by response codes #2226 #2223 Possible to implement with: https://github.com/AdguardTeam/AdGuardHome/issues/594#issuecomment-469129412 (Related issue about DNSSEC https://github.com/AdguardTeam/AdGuardHome/issues/1606)
  • Filter by response time #2501

Aikatsui avatar Apr 26 '20 08:04 Aikatsui

How about adding control characters for a more comfortable search? https://en.wikipedia.org/wiki/Control_character

ammnt avatar May 14 '20 16:05 ammnt

Do you mean extending search syntax so that you could specify additional search criteria right in the query text? Smth like what Google provides?

ameshkov avatar May 14 '20 17:05 ameshkov

Do you mean extending search syntax so that you could specify additional search criteria right in the query text? Smth like what Google provides?

Yes, but rather as a search tool in text editors like Notepad++ and Sublime Text. It will be clearer to most people.

ammnt avatar May 14 '20 17:05 ammnt

Do you mean extending search syntax so that you could specify additional search criteria right in the query text? Smth like what Google provides?

Yes, but rather as a search tool in text editors like Notepad++ and Sublime Text. It will be clearer to most people.

#594 https://github.com/AdguardTeam/AdGuardHome/issues/594#issuecomment-469129412

Aikatsui avatar May 22 '20 14:05 Aikatsui

Could we have sorting by request type? Plain DNS, DNS over TLS, DNS over HTTPS, DNS over QUIC?

seonwoolee avatar Nov 12 '20 00:11 seonwoolee

sort or filter by it?

ameshkov avatar Nov 12 '20 09:11 ameshkov

Oh whoops I meant filter

seonwoolee avatar Nov 12 '20 15:11 seonwoolee

@ainar-g & @ameshkov, please display the date or date+time combination of query instead of just time in compact mode. Otherwise, it is not clear when this request was actually made:

image

Thank you😣

ammnt avatar Jun 07 '21 19:06 ammnt

Depends on #2290.

ainar-g avatar Jul 07 '21 11:07 ainar-g

Is this feature coming soon :) ?

thomaslacour avatar Feb 22 '23 08:02 thomaslacour

really need this feature

kamanwu avatar Jul 02 '23 22:07 kamanwu

Is there any timeline for this request at all?

mbhs-scott avatar Oct 08 '24 02:10 mbhs-scott

Any news about this must have Feature ?

thibaultmeyer avatar Feb 08 '25 12:02 thibaultmeyer