How do I search for issues Resolved and Closed identifying username?

[Eder Pardeiro]

Hi,

I'm brazilian and do not speak english very well. Any form I will try explain my quest.

I need extract information for feed an worksheet with issue numbers (Resolved and Closed) for users (tecnhical support).

Actualy I can connect in the database and return the all issues in the table "jiraissue" filtering Closed issue (status 6) and Resolved (status 10114).

Now I need identify which user Close and Resolved this Issues.

In the table "jiraissue" I can see any collums which usernames, for example: (reporter, assignee, creator), but I'm not sure what the correct column is, or if what I need is actually in these columns.

How I can do this?

[Jobin Kuruvilla [Adaptavist]]

You need to look at the changegroup and changeitem tables to figure out who changed the status of an issue and when it was done.