/
Top N NXDOMAIN

Top N NXDOMAIN

Description:


Top N NXDOMAIN



Impala Query:


select qname,count(1) as tot
from dns.queries
where year=2017 and month=8 and day=8 and rcode=3
group by qname
order by tot desc
limit 500



Example Output:


1 www.zz--icann-monitoring.nl. 397151
2 pi1.nl. 45008
3 ns2.wonenbreburgnet.nl. 40982
4 ns1.wonenbreburgnet.nl. 40952
5 ns6.nayuta.nl. 39939
6 ns7.nayuta.nl. 39839

Related content

Queries per day for a domain name
Queries per day for a domain name
More like this
Unique Domain Names queried per Day
Unique Domain Names queried per Day
More like this
Count Google Open DNS Queries
Count Google Open DNS Queries
More like this
Popular labels alternative version
Popular labels alternative version
More like this
Popular labels
Popular labels
More like this
Newly queried NXDOMAINs
Newly queried NXDOMAINs
More like this