IP referrers converters

dont understand

[zechariah]

I've tried a few programs for raw log analyzing -those ready made ones. But I dont understand as why these programs does not interpret the host IP's in the raw log. Is this to be set on the server or I don't know please explain.

[mark_roach]

Analog can be configured to resolve IP addresses. See the following discussion:

[webmasterworld.com...]

[fom2001uk]

On that very subject, does anyone know how to configure a server to resolve all IPs.

Any webmasters out there with basic instructions ?

[amoore]

Firstly, you can't configure a server to reslolve ALL IP addresses. Many addresses don't have any reverse DNS for them.

You can configure many webservers to resolve the IP addresses that they can, but you configure them differently. What webserver are you running, and on what platform? (did a cursory search of the documentation turn anything up?)

[fom2001uk]

I think it's IIS4 on Windows 2000.

Every month I have to do a manual DNS lookup for the top 20 visitors for about a dozen different clients. Then I have to edit the WebTrends report before uploading it.

It gets the job done but it's a real waste of resources. Takes about 30 minutes per report :-(

[zechariah]

Wow even with webtrends you have to do that manually, man I thought it could be configured ? But anyway I also did some research myself & found out some useful sites. Will post the links here later as I dont have it here right now. Good resource I might add on the topic.

[gferd]

Using SQL Server:
1) Create a master Table of all IP's and HostNames
2) Write a cursor that iterates through them
3) Use xp_cmdshell to run nslookup against @IP
4) Update the IP address master list with the host name

[arefsum]

If you have a look at the analog home page under helper applications you will find several pre-processing DNS lookup applications. What they do, is to take your raw logs and substitute DNS resolved names where they can find them. These applications are usually very efficient, far more efficient than analog itself is.

Of course you can make your webserver do the resolving, but it is not advisable, as DNS has got a one minute timeout by default, ie if it cannot resolve the name it will try for a minute and then return a no answer. That will slow down your server quite considerably.

Alf