Set Confluence mail preferences in database

Question

Hi,

I want to make sure/control, if certain users have enabled specific settings in their email configuration on Confluence server. What would be the best approach without logging in as the user. I've got access to the database & even could change settings there.

Confluence has ScriptRunner addon available, if this helps solving the problem without manipulating the database...

Fabio Racobaldo _Catworkx_ · Answer

Hey @Jan-Peter Rusch ,

this is the query for Confluence :

SELECT *
FROM os_propertyentry
WHERE entity_key = 'confluence.prefs.email.mimetype'

Btw, a community is a place where people can search for existing questions. I'm sorry that you received an answer after long time and I hope that my answer can be usefulf for other guys.

Fabio

Jan-Peter Rusch · Answer

6 years, first answer.

Anyway, the answer you suggest is for Jira and not for Confluence...

Fabio Racobaldo _Catworkx_ · Answer

Hi @Jan-Peter Rusch ,

here a useful article about that https://confluence.atlassian.com/jirakb/retrieve-user-email-type-preferences-from-the-database-1014274906.html

Fabio