Retrieve profile pictures using SQL

[DanielG]

Hi all,

Does anyone have a suggested SQL query that would determine the location of the current profie picture of a given user?

I'm using Confluence 3.5.7

Thanks,

Daniel

[Remo Siegwart · Accepted solution]

The following query should do the job (replace "yourusername" with the username):

SELECT string_val
FROM os_propertyentry
WHERE entity_key = "confluence.user.profile.picture" AND entity_name = "CWD_yourusername"

This returns the attachment title of the profile picture if the user has a custom pic, or the path to a default avatar in Confluence. The attachment data is either in the attachment folder on the file system or in the table ATTACHMENTDATA.

Cheers
Remo