Delete attachment references from Database

[matt]

We copy our Production Jira and Confluence down to a Development environment. We do not copy attachments because we do not need them there.

I am looking for a database query to delete all the attachment references in the database, to avoid errors in logs when re-indexing both Jira and Confluence because it cannot find the attachment.

[Florian Bonniec · Accepted solution]

Hi @matt 

For JIRA it's in this table and should be returned by the query below.

select fa.id, fa.filename, ji.issuenum from fileattachment fa join jiraissue ji on ji.id = fa.issueid join project p on p.id = ji.project where p.pkey = 'PRG';

Locate Jira server file attachments in the filesystem | Jira | Atlassian Documentation

For Confluence this KB should help you.

How do I list all attachments in Confluence with their location and file sizes? | Confluence | Atlassian Documentation

Regards,