[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Reports for Exchange 2007 Receive Connector

Posted on 2010-08-27
3
Medium Priority
?
687 Views
Last Modified: 2012-06-27
I need to produce reports from the Exchange 2007 Receive Connector on the Edge Transport server.
The example of reports will be messages received and sent by 5 minutes interval, recipients status codes, etc.
I tried to follow a great article at exchange.org by Rui Silva (http://www.msexchange.org/articles_tutorials/exchange-server-2007/monitoring-operations/creating-graphical-reports-exchange-2007-part1.html) but it did not work for me (I have Office 2007 with all of the additional components installed)
0
Comment
Question by:IT-NYC
2 Comments
 
LVL 28

Accepted Solution

by:
sunnyc7 earned 2000 total points
ID: 33546255
What issues did you face ?
I used that article for reports from log-parser many a times.

I just copy pasted this on my standard log-parser installation and boom > pop-up with HTML report

"C:\Program Files (x86)\Log Parser 2.2\logparser.exe" "SELECT CASE TO_INT(ReasonData) WHEN 9 THEN 'REJECTED' WHEN 8 THEN 'REJECTED' WHEN 7 THEN 'QUARANTINED' ELSE 'ACCEPTED' END AS ReasonData2, TO_INT(mul(100.0,PropCount(*))) as Percent, count(*) as hits INTO agentAcceptedRejected.gif FROM C:\Progra~1\Microsoft\Exchan~1\TransportRoles\Logs\AgentLog\AGENT*.log GROUP BY ReasonData2 ORDER BY hits DESC" -i:CSV -nSkipLines:4  -o:CHART -chartType:PieExploded3D -chartTitle:"%% Accepted/Rejected mail" -dtlines:600 -categories:OFF -values:ON -view:ON

-
Can you better explain the problem you are trying to solve ?

thanks
0
 

Author Comment

by:IT-NYC
ID: 33546399
Will do.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

834 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