AdguardTeam / AdGuardHome

Network-wide ads & trackers blocking DNS server
https://adguard.com/adguard-home.html
GNU General Public License v3.0
25.15k stars 1.81k forks source link

Collapsed query log for time series data #1164

Open ghost opened 4 years ago

ghost commented 4 years ago

(bit hard to imagine whether AG interest to implement this feature due quite annoying task however prefer keep in issue list)

Problem Description

Sometimes i hear this question from network monitoring tools users then solution usually backup and sort logs(databases) using third-party software that designed to data analysis but some proprietary monitoring tools come with this facility as well

If we consider our one personal mobile device as example may have 6000 queries for a week and too difficult to read one by one to identify each but might be only 300-400 domains, we can view easily within 4 pages in collapsed query log. just i dont need to explain about benefits (note: it's not possible to accomplish this requirement using client based top queried domains https://github.com/AdguardTeam/AdGuardHome/issues/481#issuecomment-515673586)

Proposed Solution

To make this easy, it's convenient to set a option (check box:: collapse query log) only usable per one client with specific date and time range. (ex: max - one month) (this feature will fulfill the rest https://github.com/AdguardTeam/AdGuardHome/issues/594#issuecomment-469129412)

(query log default mode) Screenshot_188

(collapsed query log) Screenshot_177 [1] check box. [2] expand button(optional)

Screenshot_177 (optional: expand each domain queries)

https://github.com/AdguardTeam/AdGuardHome/issues/697

Ultrabenosaurus commented 4 years ago

This looks really nice, it would definitely help analysing traffic from each client as it shows exactly how many unique domains are visited and how they relate to overall request count.