create log as user visit web sites

Question

4.00/5 (1 vote)

See more:

I want to create log using sqlserver with " windows services
or may be some thing else.

my issue is
as user visit different web sites i want to create log for it

suppose 1 user visit yahoo.com then hotmail.com then google and so on

my log would be like this

sno   user id     site visit     datetime                browser
----  -------     ---------       -----
1      xyz         yahoo.com      12/12/2011 3:40:5       ie
2      xyz         hotmail.com    12/12/2011 3:45:15      ie
3      xyz         google .com    12/12/2011 4:45:15      ie

kindly let me know can we do this by making window service ?
how to done this
thanks in Advance

Posted 13-Dec-11 8:00am

qasimidl

Updated 13-Dec-11 8:03am

Mehdi Gholam

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2011-12-13T09:27:00

This is what a proxy server is for. Your clients network connection would be insulated from the internet by this proxy server. They cannot get out to the internet without it. Their browsers would be configured to use this server to go get web pages. The proxy then has to opportunity to log every single URL visited by anyone.

Since a web page is just about never a single request and response, but made up of many different URLs, requests and responses, you'll be logging more URLs that you think.

If you don't have any idea how to code TcpServer/Clients, your best bet would be to get a commerical proxy server off-the-shelf. Otherwise, it'll take you an extraordinary amount of time to learn the in's and out's of Tcp server programming and coming up with something that does what you want but also is performant and stable.

cechode · Answer 2 · 2011-12-13T08:36:00

Solution 1

how about running fiddler2 and then take the logs and update your db

Posted 13-Dec-11 8:36am

cechode