Comments on: Calculate Hourly Email Traffic using Message Tracking Logs and Log Parser https://practical365.com/calculate-hourly-email-traffic-using-message-tracking-log-parser/ Practical Office 365 News, Tips, and Tutorials Wed, 23 Feb 2022 17:10:55 +0000 hourly 1 https://wordpress.org/?v=6.6.1 By: Siva https://practical365.com/calculate-hourly-email-traffic-using-message-tracking-log-parser/#comment-237830 Wed, 23 Feb 2022 17:10:55 +0000 https://www.practical365.com/?p=4762#comment-237830 Hi Paul,

Is there a way to generate a similar report on Exchange Online(O365)?

I mean daily message tracking report count send and received.

]]> By: Joshua B https://practical365.com/calculate-hourly-email-traffic-using-message-tracking-log-parser/#comment-232150 Thu, 12 Nov 2020 20:18:02 +0000 https://www.practical365.com/?p=4762#comment-232150 can you specify a single receive connector on all servers also?

]]> By: Priya https://practical365.com/calculate-hourly-email-traffic-using-message-tracking-log-parser/#comment-230381 Mon, 20 Jul 2020 11:58:19 +0000 https://www.practical365.com/?p=4762#comment-230381 Hi Paul,
Very useful script…works like a charm!
Does this conver the time to Local time based on server time or the results are based on UTC.
Cheers
Priya

]]> By: Mohan KV https://practical365.com/calculate-hourly-email-traffic-using-message-tracking-log-parser/#comment-157771 Mon, 19 Mar 2018 09:34:04 +0000 https://www.practical365.com/?p=4762#comment-157771 Hi Paul,

Is it possible the get the message sizes along with message count through log parser?

Regards,
Mohan KV

]]> By: Victor Garcia https://practical365.com/calculate-hourly-email-traffic-using-message-tracking-log-parser/#comment-12848 Thu, 14 Jul 2016 17:43:25 +0000 https://www.practical365.com/?p=4762#comment-12848 where is more information about the option “-rpt:-1”,

]]> By: JOJO https://practical365.com/calculate-hourly-email-traffic-using-message-tracking-log-parser/#comment-12847 Wed, 21 Oct 2015 12:50:20 +0000 https://www.practical365.com/?p=4762#comment-12847 In reply to David K.

Same problem 🙁

]]> By: Leonard https://practical365.com/calculate-hourly-email-traffic-using-message-tracking-log-parser/#comment-12846 Fri, 13 Feb 2015 12:55:39 +0000 https://www.practical365.com/?p=4762#comment-12846 i fix it , from CMD works perfect .

br
leo

]]> By: Leonard https://practical365.com/calculate-hourly-email-traffic-using-message-tracking-log-parser/#comment-12845 Fri, 13 Feb 2015 12:47:37 +0000 https://www.practical365.com/?p=4762#comment-12845 I have the followin error .

what to do ???

[PS] C:Program FilesMicrosoftExchange ServerV14TransportRolesLogsMessageTracking>”C:Program Files (x86)Log Pars
er 2.2logparser.exe” “SELECT QUANTIZE(TO_LOCALTIME(TO_TIMESTAMP(EXTRACT_PREFIX(TO_STRING(EXTRACT_SUFFIX([#Fields: date-
time],0,’T’)),0,’.’), ‘hh:mm:ss’)),3600) AS Hour, COUNT(*) AS Messages from *.log where (event-id=’RECEIVE’) GROUP BY Ho
ur ORDER BY Hour ASC” -i:CSV -nSkipLines:4 -rtp:-1
Unexpected token ‘SELECT QUANTIZE(TO_LOCALTIME(TO_TIMESTAMP(EXTRACT_PREFIX(TO_STRING(EXTRACT_SUFFIX([#Fields: date-time
],0,’T’)),0,’.’), ‘hh:mm:ss’)),3600) AS Hour, COUNT(*) AS Messages from *.log where (event-id=’RECEIVE’) GROUP BY Hour
ORDER BY Hour ASC’ in expression or statement.
At line:1 char:294
+ “C:Program Files (x86)Log Parser 2.2logparser.exe” “SELECT QUANTIZE(TO_LOCALTIME(TO_TIMESTAMP(EXTRACT_PREFIX(TO_ST
RING(EXTRACT_SUFFIX([#Fields: date-time],0,’T’)),0,’.’), ‘hh:mm:ss’)),3600) AS Hour, COUNT(*) AS Messages from *.log wh
ere (event-id=’RECEIVE’) GROUP BY Hour ORDER BY Hour ASC” <<<

]]> By: <div class="apbct-real-user-wrapper"> <div class="apbct-real-user-author-name">Paul Cunningham</div> <div class="apbct-real-user-badge" onmouseover=" let popup = document.getElementById('apbct_trp_comment_id_12844'); popup.style.display = 'inline-flex'; "> <div class="apbct-real-user-popup" id="apbct_trp_comment_id_12844"> <div class="apbct-real-user-title"> <p class="apbct-real-user-popup-header">The Real Person!</p> <p class="apbct-real-user-popup-text">Author <b>Paul Cunningham</b> acts as a real person and passed all tests against spambots. Anti-Spam by CleanTalk.</p> </div> </div> </div> </div> https://practical365.com/calculate-hourly-email-traffic-using-message-tracking-log-parser/#comment-12844 Wed, 10 Sep 2014 03:09:14 +0000 https://www.practical365.com/?p=4762#comment-12844 In reply to Kyle.

What have you tried so far?

]]> By: Kyle https://practical365.com/calculate-hourly-email-traffic-using-message-tracking-log-parser/#comment-12843 Tue, 09 Sep 2014 21:09:10 +0000 https://www.practical365.com/?p=4762#comment-12843 Hi Paul,

How should someone go about rewriting this script if they do not have the “date-time” field? We are on an Exchange 2007 environment and our IIS W3 logs do have the date-time parameter. We only have “Date” and “Time” separately. When I attempt to run the script I get the error:

“Error parsing query: SELECT clause: Syntax Error: unknown field ‘#Fields: date-time’.
The closest match for input format ‘IISW3C’ is ‘date’. [Record field does not exist.]

Thanks for an assistance you can provide!

Kyle

]]>