We have a Jira(Data Center) instance with more than 400 projects and we use Zephyr Squad add-on for test case management. Is there any way we can get list of Jira projects that has Zephyr test cases?
I really appreciate your inputs on this.
Thank you !
Thank you @Matt Parks and @Pramodh M for your inputs.
I found the following SQL query to list projects in Jira that have a specific issue type along with the count of issues for each project:
SELECT p.pname AS Project_Name, COUNT(i.id) AS Issue_Count
FROM jiraissue i
JOIN project p ON i.project = p.id
JOIN issuetype it ON i.issuetype = it.id
WHERE it.pname = 'Your_Issue_Type'
GROUP BY p.pname;
Replace 'Your_Issue_Type' with the name of the specific issue type you are looking for.
I'm not a SQL guru, but it appears that query will list how many issues have the particular issue type in each project?
That definitely seems like it would work, although, depending on the size of your organization, the DBAs may not allow even read access into the Jira DB.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yeah ! I agree in some organizations the DBAs may not allow even read access into the Jira DB. Luckily, we have the access to run the select queries.
Actually, I felt it is difficult for me export the issues to CSV and group the projects because we have more than 50k issues associated with Zephyr issue type. With this query we can get the list of issues have particular issue type in each project.
Thank you !
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Without using a plugin like Power Admin or Structure, you could just run a query to pull back any issues where issuetype = Test. Make sure the Project field is in the filter and then export to a CSV (I would recommend exporting just current fields) and group on that field in the csv.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can analyze what issue types are used in Zephyr and compare that with how many projects have been used in Jira projects to see if Zephyr is used.
The add-ons such as Power Admin will help you get the reports on how many projects are configured with Teststep and Dashboards
Hope this helps
Thanks,
Pramodh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Hi @Pramodh M - Thank you for the response.
We are using "Zephyr Test" as default issue type for Zephyr, and I think it will be difficult to filter the project list if we use any JQL functionalities.
Can you please help me on how to get the reports with Power Admin add-on?
Also, is it possible to get the report with a database query?
Thanks,
Ramanji
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.