How to find projects that have a specific sender email address
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
In Jira you can set a sender email address at the project level. This will not be reflected in the global mail configuration. To find this in the UI, you will need to check each project.
How to find these projects and the sender email, that they are using?
Solution
There is no option to find this in the UI other than looking into the settings of each individual project, but you can use the following database query:
SELECT ps.propertyvalue, pe.entity_id, p.pname
FROM propertystring ps, propertyentry pe, project p
WHERE ps.id = pe.id AND pe.property_key = 'jira.project.email.sender'
AND pe.entity_id = p.id;
NOTE: This query has been tested with PostgreSQL and might need to be adjusted for other database servers.