Some useful Perl scripts to parse Windows Server DNS log files
Parses Windows Server 2003+ DNS log files. It will output to a CSV file the domain name in the form of the second-level part (example.com) as well as the number of times this record was looked up. This script was designed for a specific purpose, so it is only designed to do just that. Only A records are matched.
As I originally programmed this script to be fed into another program, I was only concered with .com, .net and .org TLD's. Therefore, if a domain name does not have this TLD, it is not matched. Edit the perl program in order to add additional TLD's to be matched if needed.
Edit the perl program in order to put in blacklisted domain names. I found it useful to enter in domain names that are used to lookup realtime blackhole lists and therefore the script comes with some default blacklists.
Download the program dnslog2csv.pl.
Prints the letter distribution of a CSV file created using the dnslog2csv.pl program
Download the program azdistrib.pl