Help Needed: Finding Attachment Paths in SQLite Database

Getting Help
1

I am currently investigating an SQLite database that stores email messages and their attachments. I have successfully extracted email bodies using the PathToDataFile column, which points to .olk files in the “Messages” folder.

However, I am struggling to locate the paths for email attachments. While I have all the .olk15MsgAttachment files saved, I cannot find a direct reference to them in the database. Here is what I have found so far:

  1. The Message_HasAttachment column confirms that an email has attachments.
  2. I have checked columns like Record_UID and Record_RecordID, but none seem to link to the attachment files.
  3. The attachment filenames (e.g., 07A3E636-A368-42EG-A1AK-ZA288G3E7D8H.olk15MsgAttachment) do not directly match any values in the database.

I am looking for a way to identify the correct attachment file for each email. Do you know where this information is stored in the database, or how I can retrieve the correct path for each attachment?

Any guidance would be greatly appreciated!

Best regards,
Samuele

2

And what it has to do with restic? As it is restic forum:)

1 Like
3

Ops, sorry on restic is possible?

4

Or Where can I ask?

5

Again - this is restic forum. Please stop spamming it with some random unrelated questions.

You should seek help in community dealing with software you have problems with. Looks for me like it is some email client maybe? Sorry but I am not sure how to help.

6

Ok sorry :+1: