Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
executable file 12 lines (11 sloc) 458 Bytes
/******************************************************************
* Author: kurt
* Email: kurt@mobux.de
* URL: www.mobux.de
* SQL File: jira_unused_projects
* Notes: List all jira projects that do not contain
* any issues
******************************************************************/
SELECT pname
FROM project p LEFT OUTER JOIN jiraissue ji ON p.id = ji.project
WHERE ji.project IS NULL;
You can’t perform that action at this time.