I need to create an exchange 2013 PowerShell that pulls email metrics for a specific user or users email address box. I would like the user name or names to be declared, The date frame to be declared as the start date and end date such as: (today and today -7 days or today-30 days). The PowerShell should send the result set in an email in with a file of excel or excel readable format. I will automate this to run this weekly or bi-weekly in the powershell or in a scheduled task.
I would like to know how many emails are received to a specific address or addresses, how many are sent, and how many are part of an email reply chain if possible. The output should be to excel or another format which excel can easily read.
The results I would like would be in table format, but have data similar to this:
Email1@[url removed, login to view] inbox email 600, unread 30, received 150, sent 125, unanswered 15, conversation 50, average time to reply in hours 16
Email2@[url removed, login to view] inbox email 500, unread 40, received 180, sent 160, unanswered 20, conversation 55, average time to reply in hours 11
I would like this to be set in a table with email and the various requests as columns.
Current email in box size as of the time run.
Unread emails at the time of the report,
Received email over the time frame specific is the variables (1, 2, 3, 4 weeks typically)
Sent email over the time frame specific is the variables (1, 2, 3, 4 weeks typically)
Unanswered email for the time frame (not replied to)
Emails in a conversation (number of emails sent and received in replies)
If possible average time to reply to a first email sent to the email box.
I will be available to work on this via screen share if necessary.
You may ask any questions you have.