It should just be a count on assignee in the jiraissue table.
There are a lot of examples here: https://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA
But I don't have a canned script that can do it.
I don't have a SQL example handy, but in the advanced search for issues
reporter = <username>
Should return what you are looking for.
reporter = <username> OR reporter WAS <username>
Might be a little more useful, on the off chance anything changed.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG