How are you all doing on this Friday?
Read from the Stipple line at the bottom
if you dont want to read about my situation.
I was told to install a proxy server, and monitor users spending the whole day on the Internet (At work)
So i installed Smoothgardian, it has built in reports but , its not something you can use.
SmoothGardian uses Squid as a proxy server. and logs all data to a access.log file.
Ive been battling for months now to get a proper tool to report off the log file. I eventually found a half decent tool called Sawmill, but even that cant do what i want, So i eventually, started creating my own solution to my problem.
I used PSFTP.exe to download the file then used Plink.exe to execute a command on the linux server to rotate the logs.
I then wrote(VB
)a utility that takes the Access.log file and converts it to a CSV file it also trimms each URL to the 3rd "/"i then use a DTS MS SQL package to upload it into a Sql2000 database using
DTSRUN scheduled every 30mins, then use crystal reports to create my own report, This all works
fine, actually it works great.
-------------------------------------------------------------------------
-------------------------------------------------------------------------
-------------------------------------------------------------------------
But the problem is when squid logs the requested url it logs the IP address
of the user aswell, We run DHCP and i think ip addresses expires every week
or 12 hours cant remember but it expires anyway.
I would like someone to show me how to get the hostname of an ip address
i'm sure getting an ip is easier, and i assume you have to query the DNS
server.
Will i be able to use Winsock, the DNS resolution protocoll is it UDP or TCP
I searched all over google but cant find anything?.
Once this is done my task is complete, then i dont have to stress on getting reports for management.
