Retrieve user email type preferences from the database
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.
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;