How to find specific user profile pictures from the Confluence attachments directory

Still need help?

The Atlassian Community is here for you.

Ask the community


You may want to locate specific user profile pictures stored in your Confluence home directory. However, the Attachments Hierarchy places all user profile pictures in various directories within the <confluence-home>/attachments/ver003/nonspaced> directory, making them difficult to find as the folders are not labeled with the parent page's content id.

(info) Please note that the way attachments are stored has changed over various versions of Confluence, so this may not work for your instance. This solution only applies to Confluence versions where attachments are stored in the Home Directory and not the database.


  1. Run the following query replacing <USERNAME> with the username of the profile you are searching for.

    Select user_mapping.lower_username , content.contentid
    from user_mapping
    LEFT JOIN content ON user_mapping.user_key = content.creator
    where content.title='user-avatar' and user_mapping.lower_username='<USERNAME>';
  2. It will return a table like:

    lower_usernamecontent id

    If you receive a table with a lower_username but no content id that means no custom profile picture was uploaded for that user

    lower_usernamecontent id
  3. Then browse to <confluence-home>/attachments/ver003/nonspaced where you can search for the specific folder matching the content id you have identified from the query.


Last modified on Nov 2, 2018

Was this helpful?

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