In R6.5, is there a way to scan for the last time users accessed their mail files? For example, if I run a scan and it turns out that 100 people haven’t accessed their mail file since 2000 and that might be a good bet that I can delete the accounts. Any idea, suggestion or recommendation would be appreciated.
-Cindy
Subject: Scan for last access?
hi cindy,
for lotus script the pseudo-code might be like that:
get the names.nsf
get the view which lists all ur peoples
loop over all these docs and use them to get the path to there mailfile.
assign the mailfile to a db-object and check the value for last modified.
a script snippets for this could be found at http://www-10.lotus.com/ldd/46dom.nsf/c21908baf7e06eb085256a39006eae9f/3184fa2e5a813af580256b61003b2e12?OpenDocument
may be u can replace NOTE_ADDED_TO_FILE by NOTE_ACCESSED???!!!
u should try that and post the result here 
if u need more help just post ur questions.
hth
alex
Subject: RE: Scan for last access?
Last modified date won’t work - the Server is modifying the file every time someone sends them mail.
You’ll have to scan the databases, as per the prior post, but extract the User Activity Detail, and look for the owner’s name - that will tell you when they last looked at the database.
Subject: RE: Scan for last access?
Thanks both of you. It’s very helpful. I will try something by myself. Thanks again.
-Cindy
Subject: RE: Scan for last access?
Did anyone ever come up with a workable solution for this?
Phil.