Can you extract a list of customers from Jira Service Management?

[Ian Swinnerton]

We have a Project set up in Jira Service Management containing four organisations, with approximately 150-300 users set up in each one.

Is there a way of extracting a list of the customers to CSV/Excel file either by organisation or full total?

I've searched around and the answer seems to be 'No' at the moment? Any ideas?

Thanks!

[Mikael Sandberg]

The only way would be to use the REST API to get the users within an organization. The endpoint you would use is this one, Get users in organization. You need the organization ID, which you can get from this endpoint, Get organizations. admin.atlassian.com can export all your portal customers, but it would not give you the specific organization that the user belongs to. 

[Hannes Obweger - JXL for Jira]

Hi @Ian Swinnerton

Just to add to @Mikael Sandberg's answer, if you happen to be interested in the organisations and users that are actually involved in issues/tickets, another option might be to export your issues, including the relevant fields (like "Organizations", or "Reporter" and "Request participants"), and extract the information in post-processing, like e.g. so:

(I'm using the app that my team and I are working on - JXL for Jira - for the export, but it should work with any other export, too.)

Of course, this would not include any organisations/users that aren't involved in any tickets - so whether this makes sense or not somewhat depends on your exact setup.

Best,

Hannes

[Ian Swinnerton]

Hi, thanks for the replies   - I'll take a closer look. The question was raised with the aim of cross referencing all the new starters and leavers within our company to ensure that they have been  added and removed as customers accordingly