Solved

Reports for Exchange 2007 Receive Connector

Posted on 2010-08-27
3
649 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
3 Comments
 
LVL 28

Accepted Solution

by:
sunnyc7 earned 500 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Learn to move / copy / export exchange contacts to iPhone without using any software. Also see the issues in configuration of exchange with iPhone to migrate contacts.
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now