DNS debug log file.

Question

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.

Thanks.

Answer 1

Maybe you can export it to CSV prior to import.
https://gallery.technet.microsoft.com/scriptcenter/Read-DNS-debug-log-and-532a8504

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

Answer 2

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

Answer 3

Thanks all!

I will try this.

Regards.