/
Number of unique clients over a month
Number of unique clients over a month
The following query gives the number of unique DNS clients (src ip addresses) per day over a given month. Note that this can run for a few minutes:
select year, month, day, count(*), count(distinct(src)) from dns.queries where year=2017 and month=10 group by year, month, day order by day asc;
This can also (obviuosly) be extented to check for a given domain name (and then runs faster), such as:
select year, month, day, count(*), count(distinct(src)) from dns.queries where domainname = 'mycooldomain.tld' AND year=2017 and month=10 group by year, month, day order by day asc;
, multiple selections available,
Related content
Unique Domain Names queried per Day
Unique Domain Names queried per Day
More like this
Queries per day for a domain name
Queries per day for a domain name
More like this
Queries per day that include the EDNS0 option edns-key-tag
Queries per day that include the EDNS0 option edns-key-tag
More like this
Count Google Open DNS Queries
Count Google Open DNS Queries
More like this
Percentage of potentially validating resolvers in a specific country
Percentage of potentially validating resolvers in a specific country
More like this
Top N NXDOMAIN
Top N NXDOMAIN
More like this