Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

What are the best practices for SLA reports?

Dante G I'm New Here Aug 17, 2022

I have been tasked with creating an SLA report for Jira.  Right now, our Jira installation is on premises, and I am writing a SQL query that for a Crystal Report that will connect directly to the DB.  However, we will be migrating to the Cloud very soon.  Will we have access to a DB once our Jira installation has been migrated to the Cloud?  If not, what are the best practices for SLA reports for Jira Cloud?

Once of the main obstacles with the SLA report involves calculating business days.  Right now, I am using another system which has calendar data.  Is it possible to calculate business days within Jira Cloud?

3 answers

0 votes

If Excel format is something you would consider, I recommend this Jira Service Management SLA reporting blog for tips and practical steps on how to create a JSM SLA Excel report.

Hi, @Dante G 

According to your question, I can recommend you to try additional SLA plugins which can cover all your needs. One of such plugins is SLA Time and Report for Jira

As for the question about "SLA report involves calculating business days", this add-on allows defining what days & time should be counted. You can set it in the Calendar settings:

calendar new.png

As for the question about reports, this add-on has two types of reports:

  1. Tables with the possibility to export the data into CSV or Excel:
    export report.png
  2. Visual reports:
    visual reports.png
    Also, if your company uses Dashboards, you can integrate there reports from this add-on.

And recently I've written an article about reports for Jira issues, maybe you'll find some useful info there:

Hope it helps. 

And if you need any help with settings or want to undestand better how this add-on works, let me know! SLA Time and Report for Jira add-on is created by my SaaSJet team, so we will be glad to help you with setting it up.


0 votes

Hello @Dante G ,

Thanks for reaching out to the community.

We have the following Blog post that gives a bunch of best practices for how to set up SLAs for accurate reporting:

and the following resources give some more details on reporting options:

And the following community threads give some recommendations for additional marketplace reporting tools:

Hope this helps


Suggest an answer

Log in or Sign up to answer