[QUOTE User="LogParser User : SkylarB"]Quote: Hi SkylarB I've never used LP to extract event logs (but i've used it for IIS logs etc). Your SQL syntax looks incorrect. Try: logparser -i:w3c "SELECT Recipient-Address FROM C:\lo...[/QUOTE] The information was very useful, thanks for your time and help

[QUOTE User="LogParser User : SkylarB"]Quote: Hi SkylarB I've never used LP to extract event logs (but i've used it for IIS logs etc). Your SQL syntax looks incorrect. Try: logparser -i:w3c "SELECT Recipient-Address FROM C:\lo...[/QUOTE] Thanks for the info.. corrected the syntax and got the results...

One other advatange of like over = is like is case insensitive. The () were fine, your problem was the lack the the single quote, required to specify a string.

Hi SkylarB I've never used LP to extract event logs (but i've used it for IIS logs etc). Your SQL syntax looks incorrect. Try: logparser -i:w3c "SELECT Recipient-Address FROM C:\logs\*.log WHERE Recipient-Address = ' tom.jones@mydomain.com '" (remove brackets around Where predicate, changed LIKE to ...

I am trying to pull a specific user (Recipient-Address) from Exchange logs for a report request by superiors. If I run logparser with this syntax it pulls every user in the Recipent-Address column logparser -i:w3c "SELECT Recipient-Address FROM C:\logs\*.log If I try to pull a specific user I get an...

Hi, I am new to log parser so please any help with the following would be greatly appreciated! I need the SQL that will report back the last times that a machine showed up in the logs by either URI-STEM or IP-ADDRESS within a date range (e.g. 23/01/2007 to 26/01/2007). If the same machine showed up in...

TO_STRING(TO_LOCALTIME(time), 'HH') AS HOUR

I'm trying to determine the # of messages that are sent from each Exchange 2003 server to the journal mailbox. I need to be able to do the following: 1. Have log parser sift through all logs in X directory. 2. Based upon those logs, show the COUNT for all messages sent to the given journaling SMTP address...

Hello all. I would like to setup logparser to parse my media server logfiles and export them to a MS SQL database. I have figured out how to export the info, not a problem. However if I schedule the task to run every 10 minute (lets say), it re-reads the info from the last time is was run and creates...

Hi, when i C:\Program Files\Log Parser 2.2>LogParser -i:W3C -e:3 "SELECT SUM(sc-bytes) fr om d:\iis_test\ex061121". I got the following error:"SELECT clause: Semantic Error: argument of SUM/AVG/PROPSUM function is not an INTEGER nor a REAL." The log file is from linux apache. I have no problem using...