Using a database log, you can track a wide variety of important statistics about your users. Many web hosting services offer these kinds of statistics, but they are often not configurable. Using ASP, and your own database tables, you can customize your logs to track anything and everything you want, and display it accordingly. The sample listed above is for this site, and displays information based on user hits. For a private web, username could be tracked, but since this site requires no login, you'll notice that username is 'Unknown' for all entries. The source code involved for this page is listed at the bottom of this page. Aside from the 'usage.asp' page, you will also need to implement the following two code snippets to make it work. The first one is to log connections. The second one logs page hits.

	'Update user database
	set conntemp=server.createobject("adodb.connection")
	cnpath="DBQ=" & server.mappath("/stevesmith/data/timesheet.mdb")
	conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath
	sqlString = "INSERT INTO user_log " & _
		" (user_id,log_date,action_code,browser,ip_address) " & _
		" VALUES ('Unknown',now,'L','" & _
		Request.ServerVariables("HTTP_USER_AGENT") & "','" & _
		Request.ServerVariables("REMOTE_HOST") & "')"
	Set logRS=conntemp.execute(sqlString)
	Set logRS=nothing

	'Update pagelog
	Dim hdrconntemp
	Dim hdrcnpath
	Dim hdrsqlString
	Dim hdrlogRS
	set hdrconntemp=server.createobject("adodb.connection")
	hdrcnpath="DBQ=" & server.mappath("/stevesmith/data/timesheet.mdb")
	hdrconntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & hdrcnpath
	hdrsqlString = "INSERT INTO page_log " & _
		" (page,log_date,action_code,browser,ip_address) " & _
		" VALUES ('" & Request.ServerVariables("SCRIPT_NAME") & "',now,'L','" & _
		Request.ServerVariables("HTTP_USER_AGENT") & "','" & _
		Request.ServerVariables("REMOTE_HOST") & "')"
	Set hdrlogRS= hdrconntemp.execute(hdrsqlString)
	Set hdrlogRS=nothing

Naturally, you'll need to create the tables and the DSN yourself for your own site. The table setup should be fairly obvious from the INSERT statements. I called the tables user_log and page_log. Lastly, you will need to display your statistics somewhere. Here is the source code for usage.asp: