Check DNS zone file using simple ruby script and verify presence of A and CNAME records using csv file

test_dns_zone.rb

require "csv"

csv = CSV.new(File.read('zone.csv'))

dns_servers = ["ns1.dns.net", "ns1.otherdns.net"]

csv.each do |row|

  type = row[0]
  name = row[1].lstrip
  result = row[2].lstrip

  if name == "@"
    host = "trexglobal.com"
  else
    host = "#{name}.trexglobal.com"
  end

  result = "#{result}." if type == "CNAME"

  puts "#{host} #{type}"

  dns_servers.each do |dns|

    command = "/usr/bin/dig @#{dns} #{host} #{type} +short"

    if type == "MX" or type == "TXT"
      puts "Skipping: #{command}"
      next
    end

    round = `#{command}`

    if round.gsub("\n", '') == result
      puts "   on #{dns} OK"
    else
      puts "   on #{dns} FAIL"
      puts "#{round.gsub("\n", '')} != #{result}"
      puts "#{command}"
    end

  end
end

zone.csv