Skip to:

SQL Reporter for Jira

works with Jira Server 8.7.0 - 9.17.5, Jira Data Center 8.7.0 - 9.17.5 and more

OVERALL RATINGS

SUPPORT

  • Partner Supported

Key highlights of the appGenerate reports using SQL queries

Generate powerful reports and statistics in SQL

Use functions like sum(), count(), group by, etc not available in JQL.Limit the columns to be displayed.

Multiple ways to view reports

Access reports in our simplified "SQL Report Viewer", dashboard gadgets or download in Excel.

Issue column will be rendered as links and drill down into issues.

Permission based control

Administrators can define user groups to prevent unauthorised access to reports

Supporting media

More details

Possible Use Cases

  • Generate information and statistics using SQL (JRASERVER-10455)
    • Generate statistical information for each individual projects
    • Generate user login statistics and trends with SQL
    • Generate health check report by identifying broken dependency or links
  • Generate powerful and flexible reports with SQL
    • Counting of number fields and display them in columns (JSWSERVER-9167)
    • Aggregating results and grouping by fields
    • Joining of issues from different projects

We are in the midst of releasing the Data Center versions.

Customers with active maintenance Server license can reach us at our ServiceDesk for a free conversion to the Data Center license.

Resources

Privacy and Security

Privacy policy

  • Atlassian's privacy policy is not applicable to the use of this app. Please refer to the privacy policy provided by this app's partner.

    Partner privacy policy

Security program

  • This app is not part of the Marketplace Bug Bounty program.

Version information

Version 1.1.1for Jira Data Center 8.7.0 - 9.17.5

Release date

Apr 4th 2024

Summary

Improvement

Details

  • Dependencies update

Payment model

Paid via Atlassian

Explore all Data Center versions

Learn and explore

  • What’s Marketplace
  • App installation
  • About Atlassian
  • Atlassian resources
  • Search and ranking
  • Atlassian events
  • Atlassian foundation

Follow