Pulling Exchange 2007 Site Stats

Posted on 2013-06-17
Medium Priority
Last Modified: 2013-06-18
We have a single instance of Exchange 2007 that supports our European sites. This consists of about 1,500 users, spead out between 2 sites in the UK, 1 in France and 2 in Italy.

The data centre & Exchange servers sit in the UK. We have 4 Exchange 2007 servers, 2 clustered database servers, and 2 client access/transport servers setup as Network Load balance. The storage groups are setup to group users by last name initial, i.e. 'A-B-C users', 'D-E-F users', 'G-H-I users' etc, so each storage group contains a mix of users from all sites. Users are split in AD, into OUs for each site, i.e.
domain.com > 
            London >
            Edinburgh >
            Paris >
            Rome >
            Milan >

We've been asked by the Site GM of France to pull the total send/receive stats for all users in the whole of France over a month period.

As far as I know, there is no way to do this in Exchange, as Exchange isn't aware of the OUs the users are in, and as all users send through the single instance, have the same domain suffix, and are mixed throughout the storage groups. So we won't be able to generate a report showing how many emails were sent/received by all French users?

Is there an easy way of doing this?
Question by:bjblackmore
LVL 63

Accepted Solution

Simon Butler (Sembee) earned 2000 total points
ID: 39252983
Exchange doesn't store that information by default anyway. The only place that information is stored is in Message Tracking, which only stores 14 days by default. Lots of tools can process the Message Tracking logs, and those will often be able to query the domain to help sort the users. However if you don't have the logs then you don't have the raw data to process.


Author Closing Comment

ID: 39255829
Thanks for the info. I think I'll tell the site GM that it's not possible as Exchange doesn't store this information, and if they want to query the logs, then they'll need to provide capital for the software/tool + a headcount to do it!

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

There are literally thousands of Exchange recovery applications out there. So how do you end up picking one that’s ideal for your business & purpose? By carefully scouting the product’s features, the benefits it offers you, & reading ample reviews f…
A method of moving multiple mailboxes (in bulk) to another database in an Exchange 2010/2013/2016 environment...
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Suggested Courses

627 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