Exchange report No. mails per user
Would anyone have, or be able to point me in the right direction to writing a report to show how many emails have been sent per user in a given period.
For example, user email@example.com sent 78 mails in the last 7 days, where the user could be a variable passed at report run time.
I am not a master of Exchange logs, so knowing what to look for to count this would be useful.
Any help would be much appreciated,
the answer to your question depends on the version of content you are using for excahnge. Let's say you are looking for messages sent by the user firstname.lastname@example.org, and enVision parses this value in the variable from in MS Exchange; which translates to the column SenderAddress in content 2.0. That means you need to create a report with two columns; SenderAddress and count(SenderAddress) such that your query runs against MS Exchange logs.
The above will give you a count of sender email addresses, but you can limit that to only one sender by adding a run time parameter where you can specify the email address you are tunning the report against; you can refer to enVIsion online help for more information on addding input parameters to a report.
Finally, when you run a report you have the ability to include results from the previous X minutes/hours/weeks/months.