Importing DNS Data

In Netbox DNS, there’s a hierarchy of components.

Views

Views scope what data is available to the requester

Zonefiles

Zonefiles enumerate records scoped to that context

Nameservers

Nameservers are the authoritative emitter for a given context

Records

Records are specific entities

View import

CSV Field Options Field Required Accessor Description name — Name description — — Description

Zonefile import

CSV Field Options Field Required Accessor Description view — name View the zone belongs to name — Name status — — Zone status default_ttl — — Default TTL description — — Description soa_ttl — — TTL for the SOA record of the zone soa_mname — name Primary name server for the zone soa_rname — — Mailbox of the zone’s administrator soa_serial_auto — — Generate the SOA serial Specify “true” or “false” soa_serial — — Serial number of the current zone data version soa_refresh — — Refresh interval for secondary name servers soa_retry — — Retry interval for secondary name servers soa_expire — — Expire time after which the zone is considered unavailable soa_minimum — — Minimum TTL for negative results, e.g. NXRRSET

Main Zones

1
2
3
4

view,name,status,description,soa_mname,soa_rname
Internal,wolfspyre.io,active,"Wolfspyre.io",coredns-01.wolfspyre.io,dns@wolfspaw.com
Internal,wolfspyre.com,active,"Wolfspyre.com",coredns-01.wolfspyre.io,dns@wolfspaw.com
Internal,wolfspaw.com,active,"Wolfspaw.com",coredns-01.wolfspyre.io,dns@wolfspaw.com

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48

name,status,description,soa_mname,soa_rname


pxe.wolfspyre.io,active,"netboot",coredns-01.wolfspyre.io,dns@wolfspaw.com
pxm.wolfspyre.io,active,"proxmox management net",coredns-01.wolfspyre.io,dns@wolfspaw.com 
pxint.wolfspyre.io,active,"proxmox secondary management net",coredns-01.wolfspyre.io,dns@wolfspaw.com
kvm.wolfspyre.io,active,"Consoles and KVMs",coredns-01.wolfspyre.io,dns@wolfspaw.com
dmz.wolfspyre.io,active,"Anything that talks both to the public and internally",coredns-01.wolfspyre.io,dns@wolfspaw.com
stor.wolfspyre.io,active,"Storage",coredns-01.wolfspyre.io,dns@wolfspaw.com
ceph.wolfspyre.io,active,"Storage - Proxmox",coredns-01.wolfspyre.io,dns@wolfspaw.com
cam.wolfspyre.io,active,"Protect/Cam Net",coredns-01.wolfspyre.io,dns@wolfspaw.com
virt.wolfspyre.io,active,"Virtualized things not exclusively proxmox",coredns-01.wolfspyre.io,dns@wolfspaw.com
vmz.wolfspyre.io,active,"VMs that live in proxmox",coredns-01.wolfspyre.io,dns@wolfspaw.com
rke.wolfspyre.io,active,"rancher nodes",coredns-01.wolfspyre.io,dns@wolfspaw.com
werkwerk.wolfspyre.io,active,"Workload RKE",coredns-01.wolfspyre.io,dns@wolfspaw.com
nfo.wolfspyre.io,active,"Logs and Metrics",coredns-01.wolfspyre.io,dns@wolfspaw.com

wolfspyre.io,active,"Wolfspyre.io",coredns-01.wolfspyre.io,dns@wolfspaw.com
wolfspyre.com,active,"Wolfspyre.com",coredns-01.wolfspyre.io,dns@wolfspaw.com
wolfspaw.com,active,"Wolfspaw.com",coredns-01.wolfspyre.io,dns@wolfspaw.com



"zone","name","type","value","status","description"
"wolfspyre.com","@",CAA,"0 iodef "mailto:loiosh@me.com"",active,"CAA Record - wolfspyre.com"
"wolfspyre.com","@",CAA,"0 iodef "mailto:ssl@wolfspaw.com"",active,"CAA Record - wolfspyre.com"
"wolfspyre.com","@",CAA,"0 issuewild "amazon.com"",active,"CAA Record - wolfspyre.com"
"wolfspyre.com","@",CAA,"0 issuewild "letsencrypt.org"",active,"CAA Record - wolfspyre.com"
"wolfspyre.com","@",CAA,"0 issuewild "pki.apple.com"",active,"CAA Record - wolfspyre.com"
"wolfspyre.com","@",CAA,"0 issuewild "pki.goog"",active,"CAA Record - wolfspyre.com"
"wolfspyre.com","@",CAA,"0 issuewild "sectigo.com"",active,"CAA Record - wolfspyre.com"


"zone","name","type","value","status","description"
"wolfspyre.io","@",CAA,"0 iodef "mailto:loiosh@me.com"",active,"CAA Record - wolfspyre.io"
"wolfspyre.io","@",CAA,"0 iodef "mailto:ssl@wolfspaw.com"",active,"CAA Record - wolfspyre.io"
"wolfspyre.io","@",CAA,"0 issuewild "amazon.com"",active,"CAA Record - wolfspyre.io"
"wolfspyre.io","@",CAA,"0 issuewild "letsencrypt.org"",active,"CAA Record - wolfspyre.io"
"wolfspyre.io","@",CAA,"0 issuewild "pki.apple.com"",active,"CAA Record - wolfspyre.io"
"wolfspyre.io","@",CAA,"0 issuewild "pki.goog"",active,"CAA Record - wolfspyre.io"
"wolfspyre.io","@",CAA,"0 issuewild "sectigo.com"",active,"CAA Record - wolfspyre.io"
"wolfspaw.com","@",CAA,"0 iodef "mailto:loiosh@me.com"",active,"CAA Record - wolfspaw.com"
"wolfspaw.com","@",CAA,"0 iodef "mailto:ssl@wolfspaw.com"",active,"CAA Record - wolfspaw.com"
"wolfspaw.com","@",CAA,"0 issuewild "amazon.com"",active,"CAA Record - wolfspaw.com"
"wolfspaw.com","@",CAA,"0 issuewild "letsencrypt.org"",active,"CAA Record - wolfspaw.com"
"wolfspaw.com","@",CAA,"0 issuewild "pki.apple.com"",active,"CAA Record - wolfspaw.com"
"wolfspaw.com","@",CAA,"0 issuewild "pki.goog"",active,"CAA Record - wolfspaw.com"
"wolfspaw.com","@",CAA,"0 issuewild "sectigo.com"",active,"CAA Record - wolfspaw.com"

Nameserver import

CSV Field Options Field Required Accessor Description name — Name description — — Description Required fields must be specified for all objects.

Related objects may be referenced by any unique attribute. For example, vrf.rd would identify a VRF by its route distinguisher.

Record import

CSV Field Options Field Required Accessor Description zone name Zone view — name View the zone belongs to type — Record Type name — Name value — Value ttl — — TTL disable_ptr — — Disable generation of a PTR record Specify “true” or “false” description — — Description status — — Record status Required fields must be specified for all objects.

Related objects may be referenced by any unique attribute. For example, vrf.rd would identify a VRF by its route distinguisher.****

“zone”,“name”,“type”,“value”,“status”,“description” “[Internal] wolfspyre.io”,“coredns-01”,A,198.18.42.53,True “[Internal] wolfspyre.io”,“coredns-02”,A,198.18.50.53,True “[Internal] wolfspyre.io”,“coredns-03”,A,192.0.2.53,True “[Internal] wolfspyre.io”,“mgt”,NS,“coredns-01.wolfspyre.io”,True “[Internal] wolfspyre.io”,“mgt”,NS,“coredns-02.wolfspyre.io”,True “[Internal] wolfspyre.io”,“mgt”,NS,“coredns-03.wolfspyre.io”,True “[Internal] wolfspyre.io”,“pxm”,NS,“coredns-01.wolfspyre.io”,True “[Internal] wolfspyre.io”,“pxm”,NS,“coredns-02.wolfspyre.io”,True “[Internal] wolfspyre.io”,“pxm”,NS,“coredns-03.wolfspyre.io”,True

“mgt.wolfspyre.io”,“mgt-core-01”,A,“198.18.42.8”,active,“90:20:c2:5e:65:01 mgt-core-01 core-01” “mgt.wolfspyre.io”,“sw-core-01”,A,“198.18.42.9”,active,“90:20:c2:5e:65:00 sw-core-01 vlan42” “mgt.wolfspyre.io”,“sw-access-10”,A,“198.18.42.10”,active,“38:21:c7:b9:e7:50 sw-access-10 38:21:c7:b9:e7:50” “mgt.wolfspyre.io”,“sw-access-11”,A,“198.18.42.11”,active,“d0:67:26:e3:8e:a0 sw-access-11 CN81HKT0G8” “mgt.wolfspyre.io”,“sw-access-12”,A,“198.18.42.12”,active,“d0:67:26:e3:7e:00 sw-access-12 CN81HKT0HG” “mgt.wolfspyre.io”,“sw-access-13”,A,“198.18.42.13”,active,“f4:03:43:72:34:30 sw-access-13 CN78HKZ0QH” “mgt.wolfspyre.io”,“sw-access-14”,A,“198.18.42.14”,active,“98:f2:b3:bf:d1:a0 sw-access-14 CN70HKZ1PQ” “mgt.wolfspyre.io”,“sw-access-15”,A,“198.18.42.15”,active,“f4:03:43:f9:8d:40 sw-access-15 CN76HL3314” “mgt.wolfspyre.io”,“sw-access-16”,A,“198.18.42.16”,active,“54:80:28:63:f0:40 sw-access-16 CN80HL25YL” “mgt.wolfspyre.io”,“sw-access-17”,A,“198.18.42.17”,active,“54:80:28:c3:d4:e0 sw-access-17 CN80HKZ2QK” “mgt.wolfspyre.io”,“sw-access-18”,A,“198.18.42.18”,active,“f4:03:43:07:e8:10 sw-access-18 CN71HKZ1ST” “mgt.wolfspyre.io”,“ap-65”,A,“198.18.42.65”,active,“90:4c:81:c1:66:e2 ap-65 CNG4K512KD” “mgt.wolfspyre.io”,“ap-66”,A,“198.18.42.66”,active,“38:17:c3:c1:47:90 ap-66 CNFRK51161” “mgt.wolfspyre.io”,“ap-67”,A,“198.18.42.67”,active,“90:4c:81:c0:51:6a ap-67 CNFYK510HF” “mgt.wolfspyre.io”,“ap-68”,A,“198.18.42.68”,active,“90:4c:81:c1:98:08 ap-68 CNG6K5139F” “mgt.wolfspyre.io”,“ap-69”,A,“198.18.42.69”,active,“90:4c:81:c2:72:00 ap-69 CNGCK51306” “mgt.wolfspyre.io”,“ap-70”,A,“198.18.42.70”,active,“90:4c:81:c1:9d:9e ap-70 CNG6K51364” “mgt.wolfspyre.io”,“ap-71”,A,“198.18.42.71”,active,“48:4a:e9:c3:7d:f4 ap-71 CNH0K5132Z” “mgt.wolfspyre.io”,“ap-74”,A,“198.18.42.74”,active,“cc:d0:83:c7:02:4e ap-74 outdoor” “mgt.wolfspyre.io”,“ap-75”,A,“198.18.42.75”,active,“c8:b5:ad:c8:66:5e ap-75 ap-365” “mgt.wolfspyre.io”,“ap-76”,A,“198.18.42.76”,active,“bc:9f:e4:c0:73:84 ap-76 CNBJSWHLL” “mgt.wolfspyre.io”,“ap-77”,A,“198.18.42.77”,active,“80:8d:b7:ce:1a:6a ap-77 CNG0HN505M” “mgt.wolfspyre.io”,“ap-81”,A,“198.18.42.81”,active,“80:8d:b7:c7:50:b2 ap-81 CNG4J0T8NF” “mgt.wolfspyre.io”,“ap-82”,A,“198.18.42.82”,active,“b0:b8:67:c3:eb:04 ap-82 USGCj0t291” “mgt.wolfspyre.io”,“ap-83”,A,“198.18.42.83”,active,“b0:b8:67:c3:11:e6 ap-83 CNG9J0T0V8”

“zone”,“name”,“type”,“value”,“status”,“description” “kvm.wolfspyre.io”,“timey”,A,“198.18.50.4”,active,“70:b3:d5:e3:d3:7f timey 0895” “wolfspyre.io”,“ntp-01”,CNAME,“timey.kvm.wolfspyre.io”,active,"" “wolfspyre.io”,“timey”,CNAME,“timey.kvm.wolfspyre.io”,active,"" “wolfspyre.com”,“timey”,CNAME,“timey.kvm.wolfspyre.io”,active,"" “wolfspaw.com”,“timey”,CNAME,“timey.kvm.wolfspyre.io”,active,"" “wolfspyre.io”,“wimey”,A,“198.18.1.4”,active,“70:b3:d5:e3:d3:96 wimey 915” “wolfspyre.io”,“ntp-02”,CNAME,“wimey.wolfspyre.io”,active,"" “wolfspyre.com”,“wimey”,CNAME,“wimey.wolfspyre.io”,active,"" “wolfspaw.com”,“wimey”,CNAME,“wimey.wolfspyre.io”,active,"" “mgt.wolfspyre.io”,“wobly”,A,“198.18.42.4”,active,“70:b3:d5:e3:d3:94 wobly 0916” “wolfspyre.com”,“wobly”,CNAME,“wobly.wolfspyre.io”,active,"" “wolfspaw.com”,“wobly”,CNAME,“wobly.wolfspyre.io”,active,"" “wolfspyre.io”,“wobly”,CNAME,“wobly.kvm.wolfspyre.io”,active,"" “wolfspyre.io”,“ntp-03”,CNAME,“wobly.kvm.wolfspyre.io”,active,""

“name”,“device_role”,“manufacturer”,“device_type”,“serial”,“status”,“site”,“comments” “wobly.mgt.wolfspyre.io”,“NTP Server”,“Uputronics”,“LEONTP”,“916”,active,“WolfspyreLabs Barn”,“70:b3:d5:e3:d3:94 198.18.42.4” “timey.kvm.wolfspyre.io”,“NTP Server”,“Uputronics”,“LEONTP”,“0895”,active,“WolfspyreLabs Barn”,“70:b3:d5:e3:d3:7f 198.18.50.4” “wimey.wolfspyre.io”,“NTP Server”,“Uputronics”,“LEONTP”,“0915”,active,“WolfspyreLabs Barn”,“70:b3:d5:e3:d3:96 198.18.1.4”

root@pandora-01:/data# mv docker/volumes/netbox_netbox-media-files/_data/netbox-dns-exporter/_default/* /tmp/zones

loiosh@kiera:/tmp/zones$ scp pandora:/tmp/zones/* . loiosh@kiera:/tmp/zones$ scp * 198.18.42.53:/tmp/zones/ loiosh@kiera:/tmp/zones$ mv * ~/NextCloud/Git_Repos/Wolfspyre.io/coredns/zones/

root@coredns-01:/tmp/zones# mv * /etc/coredns/zones/

scp pandora:/tmp/zones/* . && scp * 198.18.42.53:/tmp/zones/ && mv * ~/NextCloud/Git_Repos/Wolfspyre.io/coredns/zones/