Filter query log by date

[ameshkov]

Source: #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 Hide Redundancy #946 Let users choose the date range in the stats blocks #314)
  • Querylog, Dashboard
  • General statistics
  • Used filters stats Show Filter Blocking Stats #580
  • Per client stats Show stats by client #1336
• Keep sort result till modify or clear it manually Remember sorted, filtered status and selections on refresh #845 Remember Row Count selection on Refresh #855
• Ranges
  • Date range - day, week, month, custom [Feature request] Monthly / Yearly graphs #750 , Increase size of query log #776 (comment)
  • Time range - 5min, 10min, 1hr, custom
  • Clients range - IP, MAC, CIDR, nickname range Query log's «Client» field doesn't support searching by client nicknames #1273
• Filter options Add more filters to the query log #882 Add filter option to the filtering log #594
  (may helps to avoid implement Hide Redundancy #946 [feature request] Hide local MTR lookup in Top Board #1126)
• Collapsed query log for time series data 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 #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 Enhancements to Filters on Query Log page #1125)
• Add a "Block client" button to the Query Log Add a "Block client" button to the Query Log #1097
• Query Log screen enhancement - Show name of Filters list Query Log screen enhancement - Show name of Filters list #993
• Responsive Design on Query Log page (smartphone) Responsive Design on Query Log page (smartphone) #978
• change querylog.json location or add live view only (no write to disk) Add an option to disable writing query log to file #876
• Remember Row Count selection on Refresh Remember Row Count selection on Refresh #855
• Query Log - Basic/Detailed View Query Log - Basic/Detailed View #697
• Less Obtrusive Block/Unblock Button in Query Log Less Obtrusive Block/Unblock Button in Query Log #684
• Domain filter in query log is case-sensitive Domain filter in query log is case-sensitive #680
• Query Log - Compact Mode Query Log - Compact Mode #622
• Add filter option to the filtering log Add filter option to the filtering log #594
• See used Upstream DNS server See used Upstream DNS server #468

[Aikatsui]

Other tasks for query logs:

• Add response time to Query Log Add response time to Query Log #1601
• Allow searching in response field Search by response fields (IPs, CNAMEs, etc) in query log #1933 Possible to implement with: Add filter option to the filtering log #594 (comment)
• Allow search IP in response field Query log: Allow searching in response field #1416 Related: Add filter option to the filtering log #594 (comment)
• Filter in Query Log on Tag(s) Filter in Query Log on Tag(s) #1583
• See used Upstream DNS server See used Upstream DNS server #468 Add the used DNS to the query log #1919
• Request to add DNS query type value/filter Request to add DNS query type value/filter for Query Log. #1900
• Search by response codes Query log: search by response codes #2226 Request: Advanced query log view #2223 Possible to implement with: Add filter option to the filtering log #594 (comment)
  (Related issue about DNSSEC Percentage of queries validated with DNSSEC #1606)
• Filter by response time Need log filter by response time intervals #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 #594 (comment)

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