Which database table holds the email address for project notifications?

[Vikki Short]

Hi

Can anyone tell me how to find the project email address in the JIRA database (in the UI it is the one found in the "Notifications" section on the "Summary" page for a project).

Thanks

Vikki

[Gaston Valente · Accepted solution]

Vikki,

The table is [SCHEMANAME].propertystring

[Vikki Short]

Thanks Gaston

[Laurent Delplanque]

select ps.propertyvalue as 'notificationEmail', p.pkey
from propertyentry pe, propertystring ps, project p
where pe.property_key='jira.project.email.sender'
and pe.ID = ps.ID
and pe.ENTITY_ID = p.ID
and ps.propertyvalue is not NULL
;

[Matt Doar]

I found all projects with a From address set using

select * from propertyentry where property_key='jira.project.email.sender';