RE: logging to a database - anyone do it?
- From: "Joseph" <cismic@xxxxxxx>
- To: "'[ISAserver.org Discussion List]'" <isalist@xxxxxxxxxxxxx>
- Date: Wed, 23 Jan 2002 15:04:30 -0800
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