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