I have a large Exchange server with many hundreds of thousands of emails in thousands of folders.

I would like to generate a list of how many emails have been sent, by user, for a subset of the public folders.

If I could run SQL against the server (can I?), I would like to run a query along the lines of:

SELECT from, count(*)
FROM emails
WHERE email_is_in_folder_or_descendents('Public Folders/Customers/XYZ')
GROUP BY from

Is this possible? I have full administrator access to the server.