How to find projects that have a specific sender email address
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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:
1
2
3
4
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.
Was this helpful?