turbot/net_insights
GitHub

Query: dns_mx_record

Usage

steampipe query net_insights.query.dns_mx_record

Plugins & Tables

SQL

with domain_records as (
select
*
from
net_dns_record
where
domain = $1
and type = 'MX'
),
ns_ips as (
select
*
from
net_dns_record
where
domain in (
select
target
from
domain_records
)
)
select
domain_records.priority as "Priority",
domain_records.target as "Domain",
ns_ips.ip as "IP Address",
ns_ips.ttl as "TTL"
from
domain_records
inner join ns_ips on domain_records.target = ns_ips.domain
where
ns_ips.type = 'A'
and domain_records.type = 'MX'
order by
domain_records.priority;

Params

ArgsNameDefaultDescriptionVariable
$1domain_name_input

    Dashboards

    The query is used in the dashboards: