RE: logging to a database - anyone do it?

For one thing the field layouts are different when logging to a database
using the built in logging tool via ODBC.
If you look at the extended properties of the WC3 format and the SQL
script that is used by ODBC logging, 
You'll see the following differences for WC3 and ODBC.  I don't like
NCSA because there isn't much 
Information to really perform successful logging. While you can see that
some of the fields are the same
WC3 extended field processing in my mind is the best to use for logging
then use scripting into DB.
WC3 #Fields:                                        ODBC

date 
 
ClientHost 

time 
 
Username 

c-ip 
 
LogTime 

cs-username 
 
Service 

s-sitename 
 
Machine 

s-computername 
 
ServerIP

s-ip 
 
ProcessingTime

s-port 
 
BytesRecvd 

cs-method 
 
BytesSent 

cs-uri-stem 
 
ServiceStatus

cs-uri-query 
 
Win32Status 

sc-status 
 
Operation 

sc-win32-status 
 
Target

sc-bytes 
 
Parameters

cs-bytes time-taken 
 
 

cs-version 
 
 

cs-host 
 
 

cs(User-Agent) 
 
 

cs(Cookie) 
 
 

cs(Referer)
 
 
Joseph
 

Other related posts: