I have created an exchange 2013 PowerShell that pulls email metrics for a specific user or users email address box. It is intended to be run as a task weekly and run monthly to send a summary so I can see the number of messages the email box account is dealing with. Attached to the job is the scripts I have used. Attached to the job is the script I have so far.
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. It can be a summary email in a table in a message or it can be an excel or excel readable format. I prefer an excel file, csv, or tab delimited file, but that is not critical. This should run properly as a weekly, bi-weekly, or monthly in the powershell or in a scheduled task. It should over write the previous result set so that the information being mailed out is current and up to date.
In the results set are intended to be 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 easily read. The results I would like would be in table format.
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.
This job will remain open for at least 14 days so that I can make sure the script runs properly on my system as a scheduled task. I will not complete the task until I can verify it runs as a automated task.
I will be available to work on this via screen share if necessary.
You may ask any questions you have.