Solved

Pulling Exchange 2007 Site Stats

Posted on 2013-06-17
2
265 Views
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 >
                  Users
            Edinburgh >
                  Users
            Paris >
                  Users
            Rome >
                  Users
            Milan >
                  Users

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?
0
Comment
Question by:bjblackmore
2 Comments
 
LVL 63

Accepted Solution

by:
Simon Butler (Sembee) earned 500 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.

Simon.
0
 

Author Closing Comment

by:bjblackmore
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!
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
This article explains in simple steps how to renew expiring Exchange Server Internal Transport Certificate.
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…
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…

895 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now