We just changed the default "send mail from" address, so I want to easily see whether there are any projects that are using a non-default address. We have several hundred projects, and I don't want to visit all of them.
Update: Thanks to Boris's answer, I determined this query:
SELECT pname, propertyvalue FROM propertyentry JOIN propertystring USING (ID) JOIN project ON ENTITY_ID = project.ID WHERE PROPERTY_KEY = 'jira.project.email.sender' AND propertyvalue IS NOT NULL
Community moderators have prevented the ability to post new answers.
You will need to join the propertyentry, propertystring, and project tables to get this. The PROPERTY_KEY will be:
jira.project.email.sender
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.