Where is image/attachment metadata stored in Confluence Server v 6.15.1

[Erik DiMarco]

My organization tasked me with a side project of finding and updating certain images/attachments on our confluence server instance.

I'm trying to find specifically where the below highlighted information is stored.

When clicking on an attachment

I've already tried finding this information using Bob Swift's CLI add-on and directly on the database.

Thanks for your help!

[Diego]

Hello there!

Erik, as I understand you need to fetch some data regarding your attachments. That data being metadata used within Confluence. Is that correct?

We can take a look at the content and contentproperties table within the database. For reference we have this data model here:

Confluence Data Model

There you should be able to find what you need! Also, take a look into attachments and attachmentdata tables.

Note:

Always be extremely careful when touching your database. It is not recommended to update values directly via database. If you plan in doing so, always back up first!

Further, there are some third-party apps that can help you with this task. Such as:

Metadata for Confluence

Comala Metadata

Let us know if this helps you out!