Solved

Pulling Exchange 2007 Site Stats

Posted on 2013-06-17
2
254 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
outlook, calendar, exchange 10 31
Exchange 2007 export to PST 12 62
Creating Distribution Groups in PS 2 28
Exchange 2013 Errors 2 20
Utilizing an array to gracefully append to a list of EmailAddresses
Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
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…
The purpose of this video is to demonstrate how to set up a Mailchimp Template which will let the user create a uniform look for all of their campaigns. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mail…

747 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

13 Experts available now in Live!

Get 1:1 Help Now