Hey all - let me kick off by saying I think Log Parser is a wonderful bit of software However, using it I've run into a bit of an issue - allow me to sketch my situation first. I'm parsing MS DHCP Logfiles in order to send them to a Linux box. The obvious choice to send this information with was the...

How do I tell logparser to use tcp for syslog output. Below is what I have been trying and it does not work. Set SysLogOutput = CreateObject("MSUtil.LogQuery.SYSLOGOutputFormat") SysLogOutput.protocol =TCP ' Create query text EventQuery = "SELECT * INTO " & "@" & Trim(sls(1)) & " FROM Security, Application...

Did you look in the help file?

I am not sure if I can achive that but can I use logparser to collect Security logs but instead of sending the logs to a LogSysserver save the output as a file in Syslog format? Issam

Daniel, IO. This is great !! Much cleaner... and works. TY TY TY Regards, Mont

That was exactly what I needed. The ultimate issue here is that LogParser's Timestamp data type has no support for timezone identifiers or offsets. Something I sincerely think should be fixed in the next version. The -i:W3C format example shows that it recognizes the Date and Time fields as Timestamp...

Daniel, Thanks for engaging. Here's a bit of the file... Am hoping I have not mangled the format in presenting/anoymizing this scrap.

Could you give me an excerpt of your log file that I could play around with? I don't have any w3c files so it hampers my ability to test ideas.

Daniel, Thanks for the reply. I tried what you suggest and I got nulls for the datetime. Perhaps I am not picking up on something I should be assuming. I am trying to transform the 2 GMT timestamps in the message tracking logs to UTC formatted localtime ( i.e. 2006-03-04 17:44:40 ). I do wonder if there...

The TO_TIME function strips the date off of DateTime. Also I would think the date and time fields of W3C shouldn't require any string manipulation.. Instead of this: TO_LOCALTIME( TO_TIMESTAMP (REPLACE_STR(STRCAT(STRCAT(date,' '), time),' GMT',''),'yyyy-M-d h:m:s') ) as DateTime You should be able to...