Query exchange for sent item count by folder
- by Rich
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.