Is there a way I can access the hosted instance database to extract info into a csv file?

[bill.bennett@hanesbrands.com]

In this hosted instance of JIRA, is there a way I can access the database to extract information. e.g. user information, including username, full name, and email address into a csv

[Jeremy Largman · Accepted solution]

No, you can't access the database, but you can use the remote API. You might have to enable the Remote API in your administration console (or request it from us), but you can get user info that way. Try the CLI:

https://studio.plugins.atlassian.com/wiki/display/JCLI/JIRA+Command+Line+Interface

getUserList() is a good method:

jira --action getUserList     --group "testgroup2"  

From there, you could then do getUser programatically.

Alternatively, I believe you can request an XML backup, then restore it locally and extract info from a database that way.

[bill.bennett@hanesbrands.com]

Thanks Jeremy, I will try both your methods and see which is easier...