Solved

Pulling Exchange 2007 Site Stats

Posted on 2013-06-17
2
292 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
The new Gmail Phishing Scam going around is surprising even the savviest of users with its sophisticated techniques.
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…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

738 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