How To View the Attachment Editing History
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
You can run the following query against your database:
1
SELECT s.SPACENAME AS "Space Name", a.PAGEID, a.TITLE AS "File Name", a.ATTVERSION AS "Version", a.PAGEID, um.username AS "Modified BY", a.lastmoddate AS "Modified Date" FROM attachments a JOIN content c ON a.PAGEID = c.CONTENTID JOIN spaces s ON c.SPACEID = s.SPACEID JOIN user_mapping um ON a.lastmodifier = um.user_key ORDER BY a.ATTVERSION DESC;A user would like to view the history of an attachment such as when the attachment was modified, who modified it, and in which page the modified attachment is located. There is currently no function/feature for user to view history of the attachment in Confluence.
Was this helpful?