Generate report specific mailbox

User requesting for a report stating no of emails received for specific mailbox on a daily, weekly and monthly basis. In exchange 2010, how can I go about generating this information, is there a script of sort?
Craig PaulsenSenior Systems EngineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Daryl GawnSystem AdministratorCommented:
might be best to look into something like exchange reporter plus https://www.manageengine.com/products/exchange-reports/

depends what your budget is etc, exchange reporter monitors this and puts it into a DB so you can just query it without needing to manually keep track etc

there maybe scripts someone else can point you to but would need to be run regular enough before the message tracking logs were overwritten
0
Craig PaulsenSenior Systems EngineerAuthor Commented:
thanks, exchange reports is a great, however my client is not going to invest in this anytime soon, so a scripting option is my only option
0
Saif ShaikhServer engineer Commented:
You only want to see a single user's activities?  You could use message tracking like this:

get-messagetrackinglog -sender user@domain.com -start (get-date).adddays(-1) |select messageid -unique | measure


that will tell you the number of emails that person sent in the last 1 day.  You could use a similar command for received:


get-messagetrackinglog -recipient user@domain.com -start (get-date).adddays(-1) |select messageid -unique | measure

If you want something more robust, check out this script:
http://gallery.technet.microsoft.com/scriptcenter/bb94b422-eb9e-4c53-a454-f7da6ddfb5d6
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Craig PaulsenSenior Systems EngineerAuthor Commented:
thanks Saif Shaikh. This is extremely helpful, I ran the command "get-messagetrackinglog -recipient user@domain.com -start (get-date).adddays(-1) |select messageid -unique | measure"; which generated the total no# as per the parameter I set, 1, 7 and 30
However, is there a way I run this for a particular month, IE: for example from 1 Jan - 31 Jan 2018 as an example
0
Saif ShaikhServer engineer Commented:
You can use start date and end date.

Get-Messagetrackinglog -Recipients: Peter.abc,com -EventID "RECEIVE" -Start "5/4/2011 9:00:00 AM" -End "5/10/2011 5:00:00 PM" |ft Timestamp, Source, Sender, Recipients, MessageSubject >>C:output.txt
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Daryl GawnSystem AdministratorCommented:
its most likely your message tracking logs wont go that far back, you could schedule it every few days and keep a count somewhere so moving forward you could have access to the data. Without restoring the older logs you cant get this information historically if you dont already have something keeping track
1
Daryl GawnSystem AdministratorCommented:
what version of exchange do you have? you could check the logs to see how far back you have. In exchange 2010 it tells you the location is you expand server configuration > hub transport > right click on a server and select properties  and go to the log settings tab
0
Craig PaulsenSenior Systems EngineerAuthor Commented:
thank you both,
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Powershell

From novice to tech pro — start learning today.