/
Top N NXDOMAIN

Top N NXDOMAIN

Owned by M. Wullink
Last updated: Aug 09, 2017 by Maarten Wullink

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