turbot/net_insights
GitHub

Query: dns_parent_ns_record

Usage

steampipe query net_insights.query.dns_parent_ns_record

Plugins & Tables

SQL

with domain_list as (
select
distinct domain,
substring(
domain
from
'^(?:[^/:]*:[^/@]*@)?(?:[^/:.]*\.)+([^:/]+)'
) as tld
from
net_dns_record
where
domain = $1
),
domain_parent_server as (
select
l.domain,
d.domain as tld,
d.target as parent_server
from
net_dns_record as d
inner join domain_list as l on d.domain = l.tld
where
d.type = 'SOA'
),
domain_parent_server_ip as (
select
*
from
net_dns_record
where
domain in (
select
parent_server
from
domain_parent_server
)
),
domain_parent_server_with_ip as (
select
domain_parent_server.domain,
domain_parent_server.parent_server,
host(domain_parent_server_ip.ip) as ip_text
from
domain_parent_server
inner join domain_parent_server_ip on domain_parent_server.parent_server = domain_parent_server_ip.domain
where
domain_parent_server_ip.type = 'A'
order by
domain_parent_server.domain
),
domain_parent_server_ns_list as (
select
net_dns_record.domain,
domain_parent_server_with_ip.parent_server,
net_dns_record.target
from
net_dns_record
inner join domain_parent_server_with_ip on net_dns_record.domain = domain_parent_server_with_ip.domain
and net_dns_record.dns_server = domain_parent_server_with_ip.ip_text
and net_dns_record.type = 'NS'
order by
net_dns_record.domain
),
ns_ips as (
select
domain,
type,
ip
from
net_dns_record
where
domain in (
select
target
from
domain_parent_server_ns_list
)
and type = 'A'
order by
domain
)
select
domain_parent_server_ns_list.domain as "Domain",
domain_parent_server_ns_list.parent_server as "Parent Server",
domain_parent_server_ns_list.target as "Name Server",
ns_ips.ip as "IP Address"
from
domain_parent_server_ns_list
left join ns_ips on domain_parent_server_ns_list.target = ns_ips.domain
order by
domain_parent_server_ns_list.target;

Params

ArgsNameDefaultDescriptionVariable
$1domain_name_input