Info about Deletion Stubs?

We have a problem with one of our home grown applications that occasionally documents disappear. It is difficult to tell if and how a user deleted them.

I can restore any point in time of the NSF to restore the documents but the challenging task is to determine which point in time to restore because when a document is gone, how can I tell when exactly it was deleted?

So my question arose: is it possible to get to the deletion stub of a document (I know the UNID and could also determine the NoteID) via LotusScript or (if necessary) the C API? If so, is it then possible to find out from the deletion stub, when exactly the document was deleted and (this would be great) who deleted it?

Subject: you can get deletion stub by UNID

and I assume also by noteid if you set highest bit or the old noteid.

it must have lastmodified date, but i doubt there is any info about who created it. again you might want to match it with writes in user activity, but it’s probably hard to automatize.

Subject: don’t think so but …

you could try using NotesPeek to examine the deletion stub to see what kind of info you could extract from it. You can also code your application to capture the querydocumentdelete event and log whatever info you want that relates to the document. We ran into a similar issue many yrs ago and added a routine to log deletes so we knew whose hand to slap.

Subject: Deletion Logging Code

I wrote a blog post earlier in the year with deletion logging code. Feel free to use it if it’s of interest.http://hermes.intec.co.uk/intec/blog.nsf/dx/11052010130051HERG4L.htm