message tracking statistics - powershell noob

Hi everyone.

So ive been tasked with two small assignments, and ive managed to get the first done fairly easy, the second is making my head hurt.

task 1 was: Give me the number of recieved e-mails on our callcenter shared mailbox in a given time period.
That can be handled with something as simple as:

[Int] $Received = 0

Get-messagetrackinglog -recipients <email> -start (get-date).addhours(-48) -end (get-date).addhours(-24) -EventID Receive |ForEach { $Received++ }

Write-host "Emails Received:",$Received

Which i then can output to a html or email to the appropriate callcenter manager.

Task 2 is what i find complicated....: Give me the number of mails we have not answered within 24 hours from the list above..

So say we receive 24 mails in the last 24 hours, he wants to know how many we haven't answered of those mails within 1 day.

The emails are Sent As of the call center, so they do not appear in the original recipients messagelog, as far as i can tell, but from the individual callcenter employee. Filtering on the message subject can be troublesome. since i cant be sure (infact im positive) there wont be messages with the same subject. I suppose i could filter on the sender, but im kind of clueless as to how to go by this in a smart way.

Is it even possible to do this in powershell, or am i looking at a third party solution? Any comments are appreciated


  • Edited by DarkingDK Monday, August 17, 2015 12:23 PM Mistype
August 17th, 2015 11:43am

I will vote to ED suggestion.

Actually, You need to track every messages sent/received within given time frame.

Third party tools could be a good chance to deal in such cases. One another good application I see from Lepide i.e, http://www.lepide.com/exchange-reporter/ that seems to be a good alternative approach for you.

It helps to get the reports on the mailbox traffic of the entire network with detail information such as, all emails sent and received within a particular duration, emails sent outside and inside organization, interaction between users in a particular duration and many more.

Free Windows Admin Tool Kit Click here and download it now
August 18th, 2015 4:05am

Hi,

Based on my knowledge, there is no feature in Exchange server to meet your requirement. Please consider Ed's suggestion to try the third-party program for more help.

Regards,

August 18th, 2015 5:25am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics