Is there way to pull Issue/Task mapping per user in Jira server?

[amhasan]

Hi,

I am planning to migrate Jira server projects to Jira Cloud and due to some users being external vendors and SSO not being enabled on them, we are going to assign them verified domain email IDs. Due to this, their old task and issue assignment will be reset. 

To make the re-assignment easier, is it possible to pull a report from the server right now where I can see which external users have which task and issues were assigned to them? I can use that report to assign the same in cloud.

I could pull project and project roles through a DB script. https://confluence.atlassian.com/jirakb/retrieve-a-list-of-users-assigned-to-project-roles-in-jira-server-705954232.html

Thank you.