?
Solved

Logparser on Exchange 2007 message tracking log

Posted on 2013-10-22
4
Medium Priority
?
942 Views
Last Modified: 2013-10-29
I tried to use logparser to extract data from exchange message tracking log.


Error: WHERE clause: Syntax Error: unknown field 'recipient-address'.
The closest match for input format 'W3C' is 'date-time,client-ip,client-hostname
,server-ip,server-hostname,source-context,connector-id,source,event-id,internal-
message-id,message-id,recipient-address,recipient-status,total-bytes,recipient-c
ount,related-recipient-address,reference,message-subject,sender-address,return-p
ath,message-info'.

is same as below link
http://forums.iis.net/t/1158339.aspx

Please help
0
Comment
Question by:suriyaehnop
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 23

Expert Comment

by:Malli Boppe
ID: 39593251
Whats is that your are trying to do?
We might suggest using other options.


I have used eldump in the past which is better then logparser

http://www.ibt.ku.dk/jesper/eldump/
0
 
LVL 19

Author Comment

by:suriyaehnop
ID: 39593376
What I'm to do is, I have a bunch of message tracking log restored from backup.

I want to search if any tracking log has recipient-address as a specified and produced the report.

I saw this http://msexchangetips.blogspot.com/2006/09/exchange-exporting-and-querying.html

The poster show how do use logparser but i'm failed although follow the same command
0
 
LVL 19

Accepted Solution

by:
suriyaehnop earned 0 total points
ID: 39599504
problem solved.

the correct syntax is:

LogParser -i:CSV -nskiplines:4  "SELECT * FROM c:\log\MSGTRK20090602-1.log WHERE recipient-address like 'user@domain.com'"
0
 
LVL 19

Author Closing Comment

by:suriyaehnop
ID: 39608137
Please help to cancel this
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
This article will help to fix the below errors for MS Exchange Server 2013 I. Certificate error "name on the security certificate is invalid or does not match the name of the site" II. Out of Office not working III. Make Internal URLs and Externa…
In this video we show how to create a Shared Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Recipients >> Sha…
To show how to generate a certificate request in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Servers >> Certificates…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question