Export user's email from specific project

[Farhaad_n]

Hi, I am using jira service desk version 3.16

Is there any way to export all user's emails from one or some projects?

From UI, Database, or installing 3rd party plugin

[Ismael Jimoh]

Hi @Farhaad_n 

Unfortunately, there’s no way to export this from the UI to my knowledge. As for the database , you should be able to build a query that should provide you with this information.

I will need to check this at a later time to be able to provide you with this information though after fiddling around since I don’t have it at hand.

[Farhaad_n]

Thank you, please check it 

[Ismael Jimoh]

@Farhaad_n if the portal is open to everyone, then every users in your JIRA would be customers.

If however it is restricted, then all users under the JIRA Service Desk customer role of the project should be customers.

SELECT pra.id,pra.roletype,pra.roletypeparameter, pra.projectroleid, pr.name FROM projectroleactor AS pra LEFT JOIN projectrole AS pr ON pra.projectroleid = pr.id WHERE pra.projectroleid=<project-role-id for Service Desk Customers>// You can get the id by first querying the project role table

The following should be able to assist you here.

Regards.

[Farhaad_n]

I think I bad explain what I want, 

When I click the project tab on top of the service desk bar and select one project, there is a customer button on the left side panel, there is some organization on this page, then when I click one of them, one or some users can I see, I want all of these users from 1 project

[Farhaad_n]

no idea?