Exchange report No. mails per user

[RSAAdmin]

Hi,

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 test@test.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,

Regards,

Simon

[RSAAdmin]

Hey Simon,

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 test@test.com, 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.

Regards,

Ahmed