Query exchange for sent item count by folder
Posted
by
Rich
on Super User
See other posts from Super User
or by Rich
Published on 2012-08-27T17:47:17Z
Indexed on
2012/08/28
15:41 UTC
Read the original article
Hit count: 175
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.
© Super User or respective owner
