15 pts.
 Agent to scanl ast sent mail date on lotus
Can anyone tell how to create agent/database which will scan last sent mail date(suppose before 3 months) for all person doc on lotus server and will send alert to admin

Software/Hardware used:
ASKED: August 14, 2009  8:16 AM
UPDATED: August 14, 2009  6:17 PM

Answer Wiki:
Hi, It should be possible aith MTC (Message Tracking Stroe) if it is enabled in your environment. But I can't be positive, it's something I used a long time ago and don't have any clear idea on that particular point. Otherwise, you could use log.nsf the "Session" form documents. Scanning them by users and from the more recent to the oldest. If you have Item BodyDatabase contains "mail.box" and item BodyDocsWritten contains something more than 0 then your users sent a mail. Attention both items are not text list so parsing the values will not be as simple as Pos = ArrayGetIndex(doc.BodyDatabase ,"mail.box") if not Isnull( Pos) then if doc.BodyDocsWritten(Pos) > 0 then 'we have a mail trace LastMail(j,0) = doc.UserName LastMail(j,1) = doc.StartTime 'Jump to the next user end if end if You'll have to build arrays out of the items by splitting the values. the separator being one or many CR+LF entries (on a win platform) then you will be able to match the cells of each array. Maybe with something like ArrayDbs = split(trim(doc.BodyDatabase(0));chr$(13)) I am no sure it will work at all Attention also that if you use multiple mailboxes, you'll have to check for mail?.box in BodyDatabase item. That's the basic idea I would use in the same case, running that on all servers in my domain. Hope this helps
Last Wiki Answer Submitted:  August 14, 2009  4:24 pm  by  Ppolette   435 pts.
All Answer Wiki Contributors:  Ppolette   435 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Hi..thank for above updated..

I mean that i wanted to scan mailbox which are not used for long time for which i wanted create agent for it..
Is there any other way we can do that..
Is above will work as i am new to domino

 15 pts.