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.
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?