Need to fetch email ids of all the leads of Jira project either using a mysql query or java

[Rohan Kulkarni]

Need to fetch email ids of all the leads of Jira project either using a mysql query or java

[Henning Tietgens]

Using Script Runner plugin it's the following script:

import com.atlassian.jira.component.ComponentAccessor

def projectManager = ComponentAccessor.projectManager
def userUtil = ComponentAccessor.userUtil

String emails = ""

projectManager.getProjectObjects().each { p ->
    emails += userUtil.getUserByKey(p.leadUserKey)?.emailAddress + "\n"
}
return emails