Dashboard: DNS Records Report

This report answers the following questions:

How are the DNS records configured?
Are the parent records configured correctly?
Are the Name Server (NS) records configured correctly?
Are the Start of Authority (SOA) records configured correctly?
Are the Mail Exchange (MX) records configured correctly?

This dashboard contains 1 input and 8 tables.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-net-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select DNS Records Report dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run net_insights.dashboard.dns_records_report --share

Queries

This dashboard uses the the following queries:

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;

{
  "$1": "domain_name_input"
}

Dashboard: DNS Records Report

Usage

Queries

Tags