query

/Tag: query
17 09, 2017

JIRA Boards Extractor

By |2018-04-28T21:49:28+00:00September 17th, 2017|Linux, Scripts|0 Comments

JIRA Boards Extractor (jira-boards.pl) is the perl script which extracts data from the MySQL database of your Atlassian JIRA instance to help you identify redundant and unused JIRA boards (kanban and scrum), quick filters on each board, and associated JQL filters. The script generates a formatted Microsoft Excel file with four tabs: all_boards, scrum_boards (boards with sprints), quick_filters (per each board), and prj_filters. You can find all associated MySQL queries with tabs in the script code and adjust them in accordance with your needs.