Retrieve user email type preferences from the database

Still need help?

The Atlassian Community is here for you.

Ask the community

For Atlassian eyes only

This article is Not Validated and cannot be shared with customers.

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.


While you can set the default email type globally in Jira, users have the ability to override this setting within their own preferences. Should you need to retrieve a list of how each user has configured this setting, you can do so via the following SQL example.


Important Note

This query only returns users who have explicitly set an email type preference. If a user is not returned, they are inheriting the default global value.

from app_user au
join propertyentry pe
  on = pe.entity_id
  and pe.entity_name = 'ApplicationUser'
  and pe.property_key = 'user.notifications.mimetype'
join propertystring ps
  on =;
DescriptionSQL query to retrieve user email type preferences
ProductJira, Jira Software, Jira Service Management

Last modified on Nov 23, 2020

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.