User-Profile Data Table

[Jürgen Müller]

Hi, in which table the user data profile is stored ?

Thanks.

[Nic Brough -Adaptavist-]

Depends on what version of confluence you're on, what user management system you're using and what data you want from the profile.

Start with the tables named CWD* though, for more recent versions of Confluence

[Jürgen Müller]

it's confluence 5.3.4 and in the tables named CWD* are not the profile data. I want all profil data inculde the path to the profile picture

[Nic Brough -Adaptavist-]

Ok, that's a start. You still need to look at the CWD table if you're using internal users because the keys on it are used to tie data to users.

You'll need to define exactly what you mean by "profile data" though because there's several things you might mean, and data on users is held in many places.

Taking the one item you have named as an example... the file is treated as an attachment, and to find out what profile picture is tied to a user, you get the user's ID, then look in "values" to find out what to look for in "attachments"