Macdns Log Converter

MacDNS Log Converter is an applescript witch transforms log files from MacDNS so they can easily be edited within a spreadsheet software. I had to conduct a survey to see which sites are most accessed from within our company and found out that MacDNS log files contains all the required information, but are difficult to read. As I found no analysis software that can read MacDNS format, I wrote this script. Basically, this script extracts from the log file dropped on it the date, time, address of the requester and name of the requested site for each request, then writes it into a new text file, with basic formatting. Importing this new file in a spreadsheet (like Excel) is then just a matter of dropping the file onto Excel's icon. MacDNS Log Converter is free, edit it, modify it as you like -and send me a copy.