DAOS Estimator Methodology

After running the DAOS estimator, we noticed a few very large attachments recorded in the report and we wanted to find out which databases contained those attachments.

In a LotusScript agent I used db.Search against my NotesDBDirectory to find documents using the formula @Attachments > 0. I then examined the resulting collection to look for attachments using @AttachmentLengths. I tried a second time using the db.Search and a formula which uses @DocLength.

Long story short, the Estimator shows way more attachments than I can find using the above method. Is DAOS using some other approach to get at attachments that the formula language does differently?

Subject: response

DAOS Estimator is also using NSFSearch with the formula @Attachments to find the documents as well.

Only thing I can think of is maybe you are not examining all the $File items on the documents that are returned?

Subject: @AttachmentLengths

DAOS Estimator is telling me that I have a few hundred attachments >= 20M. When I search for documents using @DocLength > 19999999, the handful of documents returned are then checked for attachments using @Attachments(0). The ones with attachments I print to the log using @AttachmentLengths(0).

I am not seeing the quantity DAOS Estimator sees and certainly not seeing the 2 files that DAOS Estimator says are over 1G.

Are these file sizes outside the range these @Formulas capable of handling?

Subject: Trry using the -v option

That is the verbose flag and will print out all the attachment detail per database. You should be able to find the files you are looking for that way.