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.

Purpose

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.

Solution

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.

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



Last modified on Nov 23, 2020

Was this helpful?

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