How to search specific attachment type in Confluence

Still need help?

The Atlassian Community is here for you.

Ask the community


Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

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

Purpose

This page contains a few way to search and list out all attachments in Confluence that has a specific extension or file type.

In this example, we are searching for all attachment with the extension .png and other scenario involving .xls 

Solution

From the UI - Use Confluence's search syntax

  • Go to Search > AdvancedSearch

  • Choose Attachment in the Of Type section

  • Use the following search syntax to search the desired attachment type

    /.*<attachment type>.*/          Example: /.*png.*/

From the Database:

Use the following SQL query:

select c.TITLE as Attachment_Name, 
s.spacename,
c2.TITLE as Page_Title,
'http://<confluence_base_url>/pages/viewpageattachments.action?pageId='||c.PAGEID as Location
from CONTENT c
join CONTENT c2 ON c.PAGEID = c2.CONTENTID
join SPACES s on c2.SPACEID = s.SPACEID
where c.CONTENTTYPE = 'ATTACHMENT' and c.title like '%.png%';

The result will be as follows

Another example SQL query to retrieve Confluence Pages containing a type of an attachments, e.g. XLS in this case : 

select c.contentid as pageID, c.title as PageName, s.spacename from content c, spaces s
where 
c.spaceid = s.spaceid AND
c.contentid in (select c.pageid from content c 
where c.contenttype='ATTACHMENT'
AND c.title LIKE '%.xls%');

Additionally, in relation to the aforementioned SQL query, to print attachment name as well use following SQL query

select s.spacename, c.pageid, c.contentid,c.contenttype ,c.title as attachment_name from content c ,spaces s
where 
c.spaceid = s.spaceid 
AND c.contenttype='ATTACHMENT'
AND c.title LIKE '%.xls%';

(warning) The queries are validated with Postgres database so they may need slight modification for other database types. 

From the Attachment folder:

Use the following unix search syntax:

find /<confluence_home>/attachments -type f | xargs file | grep PNG

(warning) Will only work on some specific platforms.

DescriptionHow to find attachments with specific extensions in the UI, database, as well as in the hard disk.
ProductConfluence

Last modified on May 9, 2023

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.