Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

Version 1 Next »

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:


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

  • No labels