Export DNS servers configured on Windows Servers.

sms 1 Reputation point
2021-02-25T17:25:46.583+00:00

Hi,

I have a list of around 1000 servers in excel sheet which contains multiple tabs. Each Tab contains some servers.

Please let me know any command or script which can export all the DNS servers IPs configured on each of the server.

We need to export this to a csv file. The input csv file only contains host name and IP address.

The output csv should contains Host name, IP address and DNS servers.

All servers are VMware machines.

There is another excel sheet which contains only Azure Windows VMs and we need to export the same settings there too.

Azure DNS
Azure DNS
An Azure service that enables hosting Domain Name System (DNS) domains in Azure.
691 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,216 questions
Windows DHCP
Windows DHCP
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.DHCP: Dynamic Host Configuration Protocol (DHCP). A communications protocol that lets network administrators manage centrally and automate the assignment of Internet Protocol (IP) addresses in an organization's network.
1,040 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Anonymous
    2021-02-25T19:39:07.107+00:00

    This one should sort it.
    https://gist.github.com/blark/510cc216416a6160d703bedc7f880b4b

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments No comments

  2. Sunny Qi 11,051 Reputation points Microsoft Vendor
    2021-02-26T03:19:57.96+00:00

    Hi,

    Thanks for posting in Q&A platform.

    Before we go further, may I confirm with you if the issue is export DNS server configuration which including DNS server IP address or export DNS records to a csv file?

    Best Regards,
    Sunny

    ----------

    If the Answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.