Due to a recent change, when exporting issues via CSV, the Customer Organization field is exported with the Organization ID and no longer brings the name of the Organization name. While this format is better for further JIRA imports, it is not human readable and may cause some confusion.
- Create a Service Desk Project.
- Create a Customer Organization under the project. Ex: organization1
- Raise a ticket on behalf of a member of the Atlassian Organization.
- Go to the Issue Navigator and export the issue to CSV (All Fields).
The column "Custom Field (Organizations)" will display "Atlassian" on the Issue Row.
Run this SQL query from the database:
Then base on the ID to find the NAME.