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
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.