DNS debug log file.

Doria 1,246 Reputation points
2020-08-19T15:59:40.577+00:00

Hi everyone!

Is there a way to standardize the DNS service log records? Date as 'MM/DD/YYYY' format and time as 24h format? This would make it much easier when inserting the records into a database.

18862-untitled.png

Thanks.

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,039 questions
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Gloria Gu 3,896 Reputation points
    2020-08-20T07:33:54.277+00:00

    Hi,

    In regards to your issue, here're my suggestions:

    Converting the log file into CSV format would make it much easier to analyze. You can refer to the following link to use Powershell script to transform. Or you can download an application to transform a log file into CSV.
    https://gallery.technet.microsoft.com/scriptcenter/Get-DNSDebugLog-Easy-ef048bdf

    -------If my answer is helpful to you, please remember to mark them as answer. Thank you!------

    Regards
    Gloria

    0 comments
  2. Doria 1,246 Reputation points
    2020-08-20T14:25:01.483+00:00

    Thanks all!

    I will try this.

    Regards.

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.