How to monitor DNS queries on a Win 2003 server

domain-name-systemwindows-server-2003

Our main DNS server (Windows 2003 server) answers for 400+ domains. How can I see which domains it gets most queries for? Is there a way to get statistics/graphs for this?

Best Answer

There is no built-in statistics mechanism to give you any kind of per-domain query statistics.

Off the top of my head I can think of two things you could do:

Use Wireshark (probably the "text only" version, "tshark") to capture incoming DNS queries to files. You could parse the files and report on them.
Turn on the "Debug Logging" functionality on the DNS server (in the "Properties" for the DNS server), ticking only the boxes for "Incoming", "UDP", "Queries", and "Request". You'll have to parse the log file that the DNS server generates, but it may be easier than parsing output from Wireshark.

Related Solutions

Migrate 200 Domains from Windows Server 2003 DNS to Another Server

Zow! Sounds like a lot of fun.

You could use the DNSCMD utility from the Windows Support Tools to enumerate the zones, then export the zones using the /ZoneExport parameter, then import them with the /ZoneAdd parameter. It shouldn't be too bad of a script.

The export is a little quirky, because it exports to the %windir%\system32\dns directory on the server hosting the zones.

@echo off
set SRC=source-server
set DST=destination-server

for /f "usebackq delims= " %%i in (`dnscmd %SRC% /EnumZones ^| find "Primary"`) do call :DOZONE %%i
goto end

:DOZONE
dnscmd %SRC% /ZoneExport %1 %1.dns
dnscmd %DST% /ZoneAdd %1 /Primary /file \\%SRC%\C$\Windows\System32\DNS\%1.dns

:end

Admittedly, I don't have a scratch DNS server or two at hand, but the syntax should be pretty close. I tested everything but the "ZoneAdd".

Powershell – How to get DNS SERVER Statistics ? Total Queries per day ? (windows Server 2003)

Try the dnscmd and it's statistics option. It's part of the resource kit.

Best Answer

Related Solutions

Migrate 200 Domains from Windows Server 2003 DNS to Another Server

Powershell – How to get DNS SERVER Statistics ? Total Queries per day ? (windows Server 2003)

Related Topic