Database table for User Details

[Joshua Smith]

Hello

I have a query that pulls the list of users from the Postgresql database, which I use to check on the users in our wiki that are clients. However, to improve this query I would like to pull the Department field, which is set under Edit Details in the user setup. However, I have been unable to find the table that this information is stored in.

Any help appreciated.

[Joshua Smith · Accepted solution]

Nevermind, I worked it out

( SELECT OS_PROPERTYENTRY.string_val, CONTENT.USERNAME FROM OS_PROPERTYENTRY INNER JOIN CONTENT ON OS_PROPERTYENTRY.entity_id=CONTENT.CONTENTID AND OS_PROPERTYENTRY.entity_key='confluence.user.profile.department' )