Counting the mail sent/received in the last month/year

Hi All,
The Manager asked me if it's possible to know how many mails he received in the last year.
He wants to see the amount from every months
Moreover he wants to see the size as well.

If I make a message tracking I don't see the amount (the number) of the mails.
During the search the number is displayed but when ready the number is disappears.

Is that possible to create an agent for the above purpose.  
verto33Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

behendersonCommented:
Yes it is possible to make an agent for the above purpose.. but you will need to export the data outside of the mail database because once your Mgr deletes an email using standard notes views etc.. the data would be gone..  Use the UniqueID as a key and create a tracking agent that will go through every item in the inbox and sentbox and export it to either a relational database or a simple local notesdatabase
0
verto33Author Commented:
Though, I created some notes databases in the past I would need help to create such an agent.

Could you give me more explanations and codes how to do it?
0
SysExpertCommented:
1) I do not see a way to do this for old mail, ie. anything already deleted unless you have had message tracking on, and can get the info from the reports.

2) For future mail, I would recheck the reports available in the message tracking and also the statistics available in some of the activity reports.


I hope this helps !
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

verto33Author Commented:
The message tracking was on in the past year. I can make a mesage tracking in the Domino administrator, I can see the mails but I can't export it I can't send it to the person who asked for it.
Where are the reports I could copy or send?

And where are the activity reports?  
0
SysExpertCommented:
Activity reports are available on R 6.5 and  above I think.

You need to turn it on in the server config, and create the Activity Db's I think.

See the Admin client Help on how to do this.

 

I hope this helps !
0
verto33Author Commented:
I found the option "Activity logging is enabled " but the checkbox isn't marked.

I don't want to select it because I'm not the main Lotus administrator and I think it would require lots of space and we haven't enough free space on the server.
0
verto33Author Commented:
Hi All,

What about the agent behenderson mentioned? Any help to create it?
0
SysExpertCommented:
I would try it for 24 hours to see how much space is being used.

If you need more space, run a Compact with white space and copy options over a weekend.

That may clean up space


I hope this helps !
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
verto33Author Commented:
Thanks for testing it.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.