How do i find tasks that were assigned to a user that has been deactivated?

[Rita Wold]

I removed the users from the groups to deactivate their accounts. I want to find the tasks they were assigned to but nothing shows up when I search under their names.

[Shayne]

You should be able to use an advanced issue search to identify issues to which your deactivated users were assigned. The JQL would look like this:

assignee = 'username'

If that's not working for you, you can try using this SQL query to grab all the issues to which your deactivated users were assigned:

SELECT * FROM jiraissue WHERE assignee = 'username';

If you want to narrow the search down to a particular type of issue (you mentioned 'tasks' but I wasn't sure if you meant "issuetype = 'Task'"), run this query to get the ID for the issue type you're after:

SELECT id,pname FROM issuetype WHERE pname = 'issueTypeName';

Now that you have the ID for the issuetype, you can run:

SELECT * FROM jiraissue WHERE assignee = 'username' AND issuetype = 'issuetypeID';

Hope that helps!