Sample SQL'er:http://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA#ExampleSQLqueriesforJIRA-FindIssuesAffectedbyaGivenTransitioninaSpecificTimeRange Close Parent Issue:https://answers.atlassian.com/questions/726/how-do-i-get-a-parent-to-resolve-automatically-when-all-sub-tasks-are-resolved