message tracking statistics - powershell noob RRS feed

  • Question

  • 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
    Monday, August 17, 2015 11:43 AM


All replies

  • That's going to be hard.  You might want to investigate whether a third-party tool like Dell Quest MessageStats might be able to help you.

    Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."

    Monday, August 17, 2015 3:23 PM
  • 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.

    Tuesday, August 18, 2015 8:04 AM
  • 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.


    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Winnie Liang
    TechNet Community Support

    Tuesday, August 18, 2015 9:24 AM