I used the following command and sql file: COMMAND logparser file:LOGPARSER-W3C.SQL -i:W3C -o:SQL -server:192.168.#.# -dsn:fulllogfiledata -username:alpha -password:beta contents of LOGPARSER-W3C.SQL SELECT c-ip AS c_ip,TO_STRING(date,'mm/DD/yyyy') AS log_date,TO_STRING(time,'hh:mm:ss') AS log_time,...

Howdy, Copy and paste an example of the code you are executing. Maybe that will help describe the problem you are having a bit better. Remember to sanitise any IP, username and password information that maybe included with it. Geoff Thompson

same problem :<

I'm wondering if anyone knows if this can be done or exactly how. Currently, I have servers getting parsed into SQL and when it reruns, it nukes the SQL table of info and re runs. I only have it go back 12 hours to see the latest logs. What I want to do is parse the logs every 30 minutes on a single...

I love the tool, its amazing. Whats the best guess for the next release? this is a new feature which will fix a huge problem for me. thanks for all your work!

I am using logparser to parse several different W3C formatted log files into a database table with no problem, at least not till now. I am not receiving any error messages anywhere. I run logparser to parse a W3C formatted log to a SQL table, rows processed and rows output are the same number, but no...

Hi, Did you manage to find away around this problem, because im having the same issue. Im importing the security event logs into a mySQL db and im getting duplicate RecordNumbers, which should not be the case. Each RecordNumber should be unique. Cant seem to find a solution. Any advice ?

Thanks for the reply. Not quite following you though, I have created the auto increment key field on the mysql database. Now do you mean pass a null value to that field via logparser or am i missing the point? Looking at the chm help file now, cant seem to find any reference to output(SQL) auto incrementing...

I believe you have to pass NULL for the id column and/or use a special argument to the SQL output format to tell it to use auto incrementing keys. Did you check the help file's documentation for the SQL output format?

Hi all, I am trying to import security event logs from various windows 2003 servers into a mysql database. The import works fine, but on the mysql database I would like to define a auto increment (primary key) field. After creating the auto increment field log parser will not import the data as: Number...