Set Confluence mail preferences in database

[Jan-Peter Rusch]

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 _Herzum_]

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

[Jan-Peter Rusch]

6 years, first answer.

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

[Fabio Racobaldo _Herzum_]

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