Filter query log by date

[ameshkov]

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.

[tomiams]

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

[ghost]

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

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]

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

[szolin]

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

[Aikatsui]

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

[ammnt]

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

[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?

[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.

[Aikatsui]

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

[seonwoolee]

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

[ameshkov]

sort or filter by it?

[seonwoolee]

Oh whoops I meant filter

[ammnt]

@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:

Thank you😣

[ainar-g]

Depends on #2290.

[thomaslacour]

Is this feature coming soon :) ?

[kamanwu]

really need this feature