JQL query for tickets breackhing resolution SLA this month

amrita.sodhi

Hi Team

 

I am after a jql query\filter (and not report) for all tickets that were breached this month, irrespective of:

1. when the ticket was created

2. If the ticket is resolved yet or now

 

I just need to know how many tickets reached a breached status during the entire month of March.  

Joseph Chung Yin

@amrita.sodhi 

You can try something like -

project = <your JSM project key> and "Time to resolution" = breached()  (This returns issues that whose most recent SLA has missed its goal.

or 

project = <your JSM project key> and "Time to resolution" = everBreached()  (This returns issues that have missed one of their SLA goals)

This JQL will return a listing of issues where "Time to resolution" has not met your SLA configuration.  In SLA configuration you have two specific field - "Time to first response" and "Time to resolution".

Please also refer to the Atlassian's documentation on JQL query for SLA - https://support.atlassian.com/jira-service-management-cloud/docs/write-jql-queries-for-slas/  and this page on available functions - https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference (In the latter link, you can search for Jira Service Management for all the functions exclusively for JSM which included the breached() function.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.