As a JIRA Administrator, we often encounter issues which cannot be resolved with the use of JQL.
There's a spectrum of issues which requires us to use SQL to mine data from JIRA database.
Reporting and Charting
- JIRA utilisation and issue created for every projects and product
- Day to day Project usage
Attachment and File and Storage Management
- Space used by attachment for each project
- Locating of attachment in server
- User login statistic
- Identifying user that are not logged in and taking up license count
Maintenance and Health Check
- Checking database for re-indexing issue errors
- Identifying broken dependency in database level
What it does
SQL Reporter allows you to runs SQL command for data mining for statistic and report generation. It also allows user to view, display, download them for sharing. SQL Reporter also controls who are authorised to execute and view certain SQL files.
It allows tagging of SQL for easy grouping and categorize when finding the right SQL to execute.
What's next for SQL Reporter for JIRA
- Configure to use multiple datasource
- Other awesome chart like Pie, Bar, Stacked, Line, Area Charting
- Shipped with commonly used SQL Report