How to find projects that have a specific sender email address

Still need help?

The Atlassian Community is here for you.

Ask the community


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

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.


Last modified on Feb 23, 2022

Was this helpful?

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