Email request channels - where set emails is storage in database

[Beata Karkoszka]

I need to list all emails that are set to "Email request" in all projects on the Jira DC instance.
Due to the fact that there are ~200 projects, I would prefer not to go into each one to check whether the e-mails are set and what.
Where is the list of emails connected to it stored in the database?

[Marc - Devoteam · Accepted solution]

Hi @Beata Karkoszka 

I think you have to look at the tables in the DB related to JSM.

As JSM is in fact a plugin on the base system I think you can find the tables in this article; list-of-jira-server-ao-table-names-and-vendors 

This under the table row:

Jira Service Management

Plugin key:

com.atlassian.servicedesk

Developer:

Atlassian 

Version:

4.1.0-REL-0011

[Beata Karkoszka]

thank you :)