?
Solved

Exchange 2010 mailbox stats

Posted on 2012-09-10
23
Medium Priority
?
902 Views
Last Modified: 2012-09-12
I need how many emails have been received to a number of mailboxes both internal and external (would be even better to break this down) over a given period. I need individual stats for each mailbox.
I'm taking it that a prerequisite would be that I have message tracking enabled and the period would depend on how long these are retained?

Thanks
0
Comment
Question by:weight01
  • 13
  • 10
23 Comments
 
LVL 37

Accepted Solution

by:
Jamie McKillop earned 2000 total points
ID: 38385009
Hello,

Yes, you would need to have message tracking enabled for the period you want to report on. This powershell script will provide the internal portion of the reporting you are looking for - http://jamiemckillop.wordpress.com/2012/09/06/wizbang-exchange-message-tracker-2-0/

If I have some time, I try to modify to include message summaries for external recipients.

JJ
0
 
LVL 1

Author Comment

by:weight01
ID: 38386413
Thanks Jamie, the GUI loads but the form is just grey and I get the following errors:

PS] C:\Users\SFell\Desktop>$tabControl.Tabpages.add($tab1)
Exception calling "Add" with "1" argument(s): "Controls created on one thread cannot be parented to a control on a different thre
ad."
At line:1 char:25
+ $tabControl.Tabpages.add <<<< ($tab1)
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

[PS] C:\Users\SFell\Desktop>$tabControl.Tabpages.add($tab2)
Exception calling "Add" with "1" argument(s): "Controls created on one thread cannot be parented to a control on a different thre
ad."
At line:1 char:25
+ $tabControl.Tabpages.add <<<< ($tab2)
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

[PS] C:\Users\SFell\Desktop>$tabControl.Tabpages.add($tab3)
Exception calling "Add" with "1" argument(s): "Controls created on one thread cannot be parented to a control on a different thre
ad."
At line:1 char:25
+ $tabControl.Tabpages.add <<<< ($tab3)
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

[PS] C:\Users\SFell\Desktop>$tabControl.Tabpages.add($tab4)
Exception calling "Add" with "1" argument(s): "Controls created on one thread cannot be parented to a control on a different thre
ad."
At line:1 char:25
+ $tabControl.Tabpages.add <<<< ($tab4)
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

[PS] C:\Users\SFell\Desktop>
[PS] C:\Users\SFell\Desktop>
[PS] C:\Users\SFell\Desktop>$form.Controls.Add($tabControl)
Exception calling "Add" with "1" argument(s): "Controls created on one thread cannot be parented to a control on a different thre
ad."
At line:1 char:19
+ $form.Controls.Add <<<< ($tabControl)
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

[PS] C:\Users\SFell\Desktop>$form.size = new-object System.Drawing.Size(1050,800)
[PS] C:\Users\SFell\Desktop>$form.Add_Shown({$form.Activate()})
[PS] C:\Users\SFell\Desktop>$form.autoscroll = $true
[PS] C:\Users\SFell\Desktop>$form.ShowDialog()

Thanks
0
 
LVL 37

Expert Comment

by:Jamie McKillop
ID: 38386520
You need to have the Exchange Management tools installed on the system this is being run from.

JJ
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 1

Author Comment

by:weight01
ID: 38386531
I wasn't running it from EMS originally but have re-posted the error I get when run from EMS
Thanks
0
 
LVL 1

Author Comment

by:weight01
ID: 38386690
Seem to have it working using ./ when running the script..
0
 
LVL 37

Expert Comment

by:Jamie McKillop
ID: 38386694
Great.

JJ
0
 
LVL 1

Author Comment

by:weight01
ID: 38386946
Does this now cover external mail, on the Dashboard under the Organization Tools there are numbers in there for External Received Mail?

I am trying to workout how many emails one of our internal users has received over a given period whether it be from an external or internal sender.

Thanks
0
 
LVL 37

Expert Comment

by:Jamie McKillop
ID: 38387196
It covers external email. If you want received totals for a specific internal user, use the filter criteria on the Query settings tab and put that user's email address in the Recipients field. Cliick Get Logs. On the email summaries tab, you will see totals for internal received, internal sent, external recieved, and external sent.

JJ
0
 
LVL 1

Author Comment

by:weight01
ID: 38387220
Cheers, great help!
0
 
LVL 1

Author Comment

by:weight01
ID: 38387432
I am getting the following error when searching on most mailboxes:

01/01/2012 15:37:45
11/09/2012 16:38:05
ForEach-Object : Exception calling "ContainsKey" with "1" argument(s): "Key cannot be null.
Parameter name: key"
At C:\Users\SFell\Desktop\wbmsgtrack.ps1:358 char:56
+                 Invoke-Command -ScriptBlock $Scblk | ForEach-Object <<<<  {
    + CategoryInfo          : NotSpecified: (:) [ForEach-Object], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException,Microsoft.PowerShell.Commands.ForEachObjectCommand

Thanks
0
 
LVL 37

Expert Comment

by:Jamie McKillop
ID: 38387527
That means your query didn't come back with any results. If you are looking to report on multiple mailboxes, I would just leave the filter options unchecked. You will then get results back for every recipient at once and you can sort the email summary grid by email address to find the user you want.

JJ
0
 
LVL 1

Author Comment

by:weight01
ID: 38387666
No joy.  I am gathering the data month by month using the Between option under Select Date Range.  The only two months that return any data are July and August, the rest of the year return the above error both with or with using the filter (the logs files are there for the full year).

Thanks
0
 
LVL 37

Expert Comment

by:Jamie McKillop
ID: 38387681
You have a full year of tracking logs? Can you search the tracking logs for that time period through the Message Log Tracker in EMC?

JJ
0
 
LVL 1

Author Comment

by:weight01
ID: 38387828
We have a full year, I'll try tracking through EMC and see if it does and let you know.

Thanks
0
 
LVL 1

Author Comment

by:weight01
ID: 38388246
Jamie, delivery reports are showing for the full year.

Thanks
0
 
LVL 37

Expert Comment

by:Jamie McKillop
ID: 38388398
Do you end up getting any results, despite the error?

JJ
0
 
LVL 1

Author Comment

by:weight01
ID: 38388506
Data is populated but clearly not all.  The green search progress indicator stops and does not reach the end and hangs.
2012-09-11-20-46-58.jpg
0
 
LVL 1

Author Comment

by:weight01
ID: 38388617
I have searched every day in May individually and not one day completed, they seem to stop between 60-70% completion.
0
 
LVL 37

Expert Comment

by:Jamie McKillop
ID: 38390683
There must be some logs that are causing the script to fail. I'll add some error checking and get back to you.

JJ
0
 
LVL 1

Author Comment

by:weight01
ID: 38390717
Thanks

I'm just comparing some logs in excel
0
 
LVL 37

Expert Comment

by:Jamie McKillop
ID: 38390830
I've added some statments to check if the key values are null. Please try this and let me know how it works.

JJ
wbmsgtrack.txt
0
 
LVL 1

Author Comment

by:weight01
ID: 38391291
Jamie, working fine now, running reports for each month.  Thanks for your help and persistance, if I could give you more points.....I would

Cheers
0
 
LVL 37

Expert Comment

by:Jamie McKillop
ID: 38391367
Glad to hear it is working.

JJ
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On September 18, Experts Exchange launched the first installment of the Help Bell, a new feature for Premium Members, Team Accounts, and Qualified Experts. The Help Bell will serve as an additional tool to help teams increase question visibility.
How to effectively resolve the number one email related issue received by helpdesks.
To show how to create a transport rule in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Rules tab.:  To cr…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question