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 Page History

« Previous Version 2 Current »

Description:


Get the percentage of potentially validating resolvers in a specific country. Note however, that the fact that a resolver asks for DS or DNSKEY records does not necessarily mean that it is actually validating.



Impala Query:


select dnssec.number / total.number as percentage
from
(
select count(distinct src) as number
from dns.queries
where country='CH') total
join
(
select count(distinct src) as number
from dns.queries
where edns_do=true
and (qtype = 43 or qtype = 48)
and country='CH' ) dnssec on 1=1;




Example Output:


percentage
0.1141771161334799

  • No labels