Make DNSCMD Ageing values readable

DNSCMD data gives hours since 1/1/1600 00:00 (Source:Export DNS records to Excel to read time stamps and static records) but Excel is configured with 1/1/1900 00:00, so we need to remove the extra 300 years from our aging value first.

We'll use constant 2620924 here.
(AGE: value -2620924)/24 gives us day count from 1/1/1900 00:00

So 1/1/1900 + the day count will give us the Time Stamp value in a format we can understand.


Verified example:
AGE=3580157
=((AGE-2620924)/24)+(1/1/1900)=04/06/2009 which is same as DNS console shows.

If you have a server with multiple NICs and if it is consisting to register it's IP address to DNS server even while you uncheck the "register this connection's addresses in DNS" option, I recommend you to create the registry entry below

Create a DWORD named  DisableDynamicUpdate under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters and assign value 1 .



Or you can run the command below to easily create the record.

reg add HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters /v DisableDynamicUpdate /t REG_DWORD /d 1 /f

Normally this method shown for 2000 and 2003 servers in MS pages, but it is also working for 2008.